Dear Suthar, Can I have your private contact?
regards, On Fri, 4 Jun 2021 at 06:25, Lalit Suthar <[email protected]> wrote: > my pleasure :) > > On Thu, 3 Jun 2021 at 20:28, Eugene TUYIZERE <[email protected]> > wrote: > >> Dear Suthar, >> >> Thank you very much. It works well. >> >> >> On Thu, 3 Jun 2021 at 16:48, Lalit Suthar <[email protected]> >> wrote: >> >>> not sure but maybe this can work inside views replace >>> chart = { >>> 'chart': {'type': 'column'}, >>> 'title': {'text': 'Previous statistics'}, >>> 'xAxis': {'replist': replist}, >>> 'series': [arriva_days] >>> } >>> with >>> chart = { >>> 'chart': {'type': 'column'}, >>> 'title': {'text': 'Previous statistics'}, >>> 'xAxis': {'categories': replist}, >>> 'series': [arriva_days] >>> } >>> >>> On Thu, 3 Jun 2021 at 18:00, Eugene TUYIZERE <[email protected]> >>> wrote: >>> >>>> This what I have in summarizedchart.html: >>>> >>>> {% extends "layouts/base.html" %} >>>> {% load static %} >>>> {% block title %} Repport {% endblock %} >>>> >>>> <!-- Specific CSS goes HERE --> >>>> {% block stylesheets %}{% endblock stylesheets %} >>>> >>>> {% block content %} >>>> >>>> <div class="pcoded-main-container"> >>>> <div class="pcoded-content"> >>>> <div class="col-lg-12"> >>>> <div class="card table-card"> >>>> <div class="card-header"> >>>> <h5>Report</h5> >>>> >>>> <hr> >>>> >>>> <script src="{% static 'assets/js/chart.js' %}"></script> >>>> >>>> <div id="container"></div> >>>> <script> >>>> Highcharts.chart('container', {{ chart|safe }}); >>>> </script> >>>> </div> >>>> </div> >>>> </div> >>>> </div> >>>> </div> >>>> {% endblock content %} >>>> {% block custom_js %} >>>> >>>> {% endblock custom_js %} >>>> >>>> On Thu, 3 Jun 2021 at 14:22, Lalit Suthar <[email protected]> >>>> wrote: >>>> >>>>> so the view is not giving error right now but maybe we are passing the >>>>> data in different format then the chart is expecting. >>>>> What are you using for drawing the chart? can I see the code inside >>>>> "summarizedchart.html" >>>>> >>>>> On Thu, 3 Jun 2021 at 17:43, Eugene TUYIZERE <[email protected]> >>>>> wrote: >>>>> >>>>>> Dear Suthar, >>>>>> >>>>>> You saved my day. Once more, the chart is displayed but the date is >>>>>> not displayed on Xaxis. This how it is: >>>>>> >>>>>> [image: image.png] >>>>>> >>>>>> Th codes are: >>>>>> def reqChart(request): >>>>>> current_date = date.today() >>>>>> days_before = date.today()-timedelta(days=30) >>>>>> datelist = Customer_Requests.objects.values("arrival_date").annotate( >>>>>> num_req=Count("request_name")).order_by('-arrival_date')[:20:-1] >>>>>> replist = list() >>>>>> sumdata = list() >>>>>> for listd in datelist: >>>>>> replist.append(listd['arrival_date']) >>>>>> sumdata.append(listd['num_req']) >>>>>> arriva_days = { >>>>>> 'name': 'Datess', >>>>>> 'data': sumdata, >>>>>> 'color': 'green' >>>>>> } >>>>>> chart = { >>>>>> 'chart': {'type': 'column'}, >>>>>> 'title': {'text': 'Previous statistics'}, >>>>>> 'xAxis': {'replist': replist}, >>>>>> 'series': [arriva_days] >>>>>> } >>>>>> dump = json.dumps(chart,cls=DjangoJSONEncoder) >>>>>> return render(request,'summarizedchart.html',{'chart': dump}) >>>>>> >>>>>> >>>>>> On Thu, 3 Jun 2021 at 13:27, lalit suthar <[email protected]> >>>>>> wrote: >>>>>> >>>>>>> Hi there! >>>>>>> make these couple of changes >>>>>>> >>>>>>> 1) from django.core.serializers.json import DjangoJSONEncoder >>>>>>> 2) dump3 = json.dumps(chart3, cls=DjangoJSONEncoder) >>>>>>> On Thursday, 3 June 2021 at 16:18:15 UTC+5:30 [email protected] >>>>>>> wrote: >>>>>>> >>>>>>>> Dear Suthar, >>>>>>>> >>>>>>>> Your idea works well , but I want now to display the result on >>>>>>>> chart. Below is the code I am trying to use: >>>>>>>> but Am getting the error message: >>>>>>>> >>>>>>>> Exception Value: >>>>>>>> >>>>>>>> Object of type date is not JSON serializable >>>>>>>> >>>>>>>> >>>>>>>> def reqChart(request): >>>>>>>> aa = Customer_Requests.objects.values("arrival_date").annotate( >>>>>>>> num_req=Count("request_name")).order_by('-arrival_date')[:20:-1] >>>>>>>> print(aa) >>>>>>>> datesb = list() >>>>>>>> sumdata = list() >>>>>>>> for dd in aa: >>>>>>>> datesb.append(dd['arrival_date']) >>>>>>>> sumdata.append(dd['num_req']) >>>>>>>> arriva_days = { >>>>>>>> 'name': 'Datess', >>>>>>>> 'data': sumdata, >>>>>>>> 'color': 'green' >>>>>>>> } >>>>>>>> chart3 = { >>>>>>>> 'chart': {'type': 'column'}, >>>>>>>> 'title': {'text': 'Previous statistics'}, >>>>>>>> 'xAxis': {'datesb': datesb}, >>>>>>>> 'series': [arriva_days] >>>>>>>> } >>>>>>>> dump3 = json.dumps(chart3) >>>>>>>> return render(request,'summarizedchart.html',{'chart3': dump3}) >>>>>>>> >>>>>>>> Please once again >>>>>>>> >>>>>>>> regards, >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> On Thu, 3 Jun 2021 at 09:00, lalit suthar <[email protected]> >>>>>>>> wrote: >>>>>>>> >>>>>>>>> this will do >>>>>>>>> >>>>>>>>> Customer_Requests.objects.values("arrival_date").annotate(num_req=Count("request_name")).order_by("-id")[:30:-1] >>>>>>>>> >>>>>>>>> On Thursday, 3 June 2021 at 11:37:26 UTC+5:30 [email protected] >>>>>>>>> wrote: >>>>>>>>> >>>>>>>>>> to display last 30 records you can write your code like this: >>>>>>>>>> Customer_Requests.objects.all()[-30] >>>>>>>>>> >>>>>>>>>> On Thu, Jun 3, 2021 at 10:51 AM Eugene TUYIZERE < >>>>>>>>>> [email protected]> wrote: >>>>>>>>>> >>>>>>>>>>> Dear Latit, >>>>>>>>>>> >>>>>>>>>>> Thank you very much. Now how can I display 30 last records? >>>>>>>>>>> Regardless of how many records I may have ! Just the last 30 >>>>>>>>>>> records! >>>>>>>>>>> >>>>>>>>>>> Thank you >>>>>>>>>>> >>>>>>>>>>> On Thu, 3 Jun 2021 at 06:51, Lalit Suthar <[email protected]> >>>>>>>>>>> wrote: >>>>>>>>>>> >>>>>>>>>>>> > in brief, I want to transform this query in django query >>>>>>>>>>>> this will be equivalent to this query in django >>>>>>>>>>>> >>>>>>>>>>>> Customer_Requests.objects.values("arrival_date").annotate(num_req=Count("request_name")) >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> On Thu, 3 Jun 2021 at 02:02, Eugene TUYIZERE < >>>>>>>>>>>> [email protected]> wrote: >>>>>>>>>>>> >>>>>>>>>>>>> in brief, I want to transform this query in django query >>>>>>>>>>>>> >>>>>>>>>>>>> [image: image.png] >>>>>>>>>>>>> >>>>>>>>>>>>> On Wed, 2 Jun 2021 at 21:56, Eugene TUYIZERE < >>>>>>>>>>>>> [email protected]> wrote: >>>>>>>>>>>>> >>>>>>>>>>>>>> Dear Sebatian, >>>>>>>>>>>>>> >>>>>>>>>>>>>> This is what I get: >>>>>>>>>>>>>> >>>>>>>>>>>>>> SELECT `crms_customer_requests`.`arrival_date`, >>>>>>>>>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM >>>>>>>>>>>>>> `crms_customer_requests` WHERE >>>>>>>>>>>>>> `crms_customer_requests`.`arrival_date` >= >>>>>>>>>>>>>> 2021-05-03 GROUP BY `crms_customer_requests`.`arrival_date` >>>>>>>>>>>>>> ORDER BY NULL >>>>>>>>>>>>>> SELECT `crms_customer_requests`.`arrival_date`, >>>>>>>>>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM >>>>>>>>>>>>>> `crms_customer_requests` WHERE >>>>>>>>>>>>>> `crms_customer_requests`.`arrival_date` >= >>>>>>>>>>>>>> 2021-05-04 GROUP BY `crms_customer_requests`.`arrival_date` >>>>>>>>>>>>>> ORDER BY NULL >>>>>>>>>>>>>> SELECT `crms_customer_requests`.`arrival_date`, >>>>>>>>>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM >>>>>>>>>>>>>> `crms_customer_requests` WHERE >>>>>>>>>>>>>> `crms_customer_requests`.`arrival_date` >= >>>>>>>>>>>>>> 2021-05-05 GROUP BY `crms_customer_requests`.`arrival_date` >>>>>>>>>>>>>> ORDER BY NULL >>>>>>>>>>>>>> SELECT `crms_customer_requests`.`arrival_date`, >>>>>>>>>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM >>>>>>>>>>>>>> `crms_customer_requests` WHERE >>>>>>>>>>>>>> `crms_customer_requests`.`arrival_date` >= >>>>>>>>>>>>>> 2021-05-06 GROUP BY `crms_customer_requests`.`arrival_date` >>>>>>>>>>>>>> ORDER BY NULL >>>>>>>>>>>>>> SELECT `crms_customer_requests`.`arrival_date`, >>>>>>>>>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM >>>>>>>>>>>>>> `crms_customer_requests` WHERE >>>>>>>>>>>>>> `crms_customer_requests`.`arrival_date` >= >>>>>>>>>>>>>> 2021-05-07 GROUP BY `crms_customer_requests`.`arrival_date` >>>>>>>>>>>>>> ORDER BY NULL >>>>>>>>>>>>>> SELECT `crms_customer_requests`.`arrival_date`, >>>>>>>>>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM >>>>>>>>>>>>>> `crms_customer_requests` WHERE >>>>>>>>>>>>>> `crms_customer_requests`.`arrival_date` >= >>>>>>>>>>>>>> 2021-05-08 GROUP BY `crms_customer_requests`.`arrival_date` >>>>>>>>>>>>>> ORDER BY NULL >>>>>>>>>>>>>> SELECT `crms_customer_requests`.`arrival_date`, >>>>>>>>>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM >>>>>>>>>>>>>> `crms_customer_requests` WHERE >>>>>>>>>>>>>> `crms_customer_requests`.`arrival_date` >= >>>>>>>>>>>>>> 2021-05-09 GROUP BY `crms_customer_requests`.`arrival_date` >>>>>>>>>>>>>> ORDER BY NULL >>>>>>>>>>>>>> SELECT `crms_customer_requests`.`arrival_date`, >>>>>>>>>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM >>>>>>>>>>>>>> `crms_customer_requests` WHERE >>>>>>>>>>>>>> `crms_customer_requests`.`arrival_date` >= >>>>>>>>>>>>>> 2021-05-10 GROUP BY `crms_customer_requests`.`arrival_date` >>>>>>>>>>>>>> ORDER BY NULL >>>>>>>>>>>>>> SELECT `crms_customer_requests`.`arrival_date`, >>>>>>>>>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM >>>>>>>>>>>>>> `crms_customer_requests` WHERE >>>>>>>>>>>>>> `crms_customer_requests`.`arrival_date` >= >>>>>>>>>>>>>> 2021-05-11 GROUP BY `crms_customer_requests`.`arrival_date` >>>>>>>>>>>>>> ORDER BY NULL >>>>>>>>>>>>>> SELECT `crms_customer_requests`.`arrival_date`, >>>>>>>>>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM >>>>>>>>>>>>>> `crms_customer_requests` WHERE >>>>>>>>>>>>>> `crms_customer_requests`.`arrival_date` >= >>>>>>>>>>>>>> 2021-05-12 GROUP BY `crms_customer_requests`.`arrival_date` >>>>>>>>>>>>>> ORDER BY NULL >>>>>>>>>>>>>> SELECT `crms_customer_requests`.`arrival_date`, >>>>>>>>>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM >>>>>>>>>>>>>> `crms_customer_requests` WHERE >>>>>>>>>>>>>> `crms_customer_requests`.`arrival_date` >= >>>>>>>>>>>>>> 2021-05-13 GROUP BY `crms_customer_requests`.`arrival_date` >>>>>>>>>>>>>> ORDER BY NULL >>>>>>>>>>>>>> SELECT `crms_customer_requests`.`arrival_date`, >>>>>>>>>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM >>>>>>>>>>>>>> `crms_customer_requests` WHERE >>>>>>>>>>>>>> `crms_customer_requests`.`arrival_date` >= >>>>>>>>>>>>>> 2021-05-14 GROUP BY `crms_customer_requests`.`arrival_date` >>>>>>>>>>>>>> ORDER BY NULL >>>>>>>>>>>>>> SELECT `crms_customer_requests`.`arrival_date`, >>>>>>>>>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM >>>>>>>>>>>>>> `crms_customer_requests` WHERE >>>>>>>>>>>>>> `crms_customer_requests`.`arrival_date` >= >>>>>>>>>>>>>> 2021-05-15 GROUP BY `crms_customer_requests`.`arrival_date` >>>>>>>>>>>>>> ORDER BY NULL >>>>>>>>>>>>>> SELECT `crms_customer_requests`.`arrival_date`, >>>>>>>>>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM >>>>>>>>>>>>>> `crms_customer_requests` WHERE >>>>>>>>>>>>>> `crms_customer_requests`.`arrival_date` >= >>>>>>>>>>>>>> 2021-05-16 GROUP BY `crms_customer_requests`.`arrival_date` >>>>>>>>>>>>>> ORDER BY NULL >>>>>>>>>>>>>> SELECT `crms_customer_requests`.`arrival_date`, >>>>>>>>>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM >>>>>>>>>>>>>> `crms_customer_requests` WHERE >>>>>>>>>>>>>> `crms_customer_requests`.`arrival_date` >= >>>>>>>>>>>>>> 2021-05-17 GROUP BY `crms_customer_requests`.`arrival_date` >>>>>>>>>>>>>> ORDER BY NULL >>>>>>>>>>>>>> SELECT `crms_customer_requests`.`arrival_date`, >>>>>>>>>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM >>>>>>>>>>>>>> `crms_customer_requests` WHERE >>>>>>>>>>>>>> `crms_customer_requests`.`arrival_date` >= >>>>>>>>>>>>>> 2021-05-18 GROUP BY `crms_customer_requests`.`arrival_date` >>>>>>>>>>>>>> ORDER BY NULL >>>>>>>>>>>>>> SELECT `crms_customer_requests`.`arrival_date`, >>>>>>>>>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM >>>>>>>>>>>>>> `crms_customer_requests` WHERE >>>>>>>>>>>>>> `crms_customer_requests`.`arrival_date` >= >>>>>>>>>>>>>> 2021-05-19 GROUP BY `crms_customer_requests`.`arrival_date` >>>>>>>>>>>>>> ORDER BY NULL >>>>>>>>>>>>>> SELECT `crms_customer_requests`.`arrival_date`, >>>>>>>>>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM >>>>>>>>>>>>>> `crms_customer_requests` WHERE >>>>>>>>>>>>>> `crms_customer_requests`.`arrival_date` >= >>>>>>>>>>>>>> 2021-05-20 GROUP BY `crms_customer_requests`.`arrival_date` >>>>>>>>>>>>>> ORDER BY NULL >>>>>>>>>>>>>> SELECT `crms_customer_requests`.`arrival_date`, >>>>>>>>>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM >>>>>>>>>>>>>> `crms_customer_requests` WHERE >>>>>>>>>>>>>> `crms_customer_requests`.`arrival_date` >= >>>>>>>>>>>>>> 2021-05-21 GROUP BY `crms_customer_requests`.`arrival_date` >>>>>>>>>>>>>> ORDER BY NULL >>>>>>>>>>>>>> SELECT `crms_customer_requests`.`arrival_date`, >>>>>>>>>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM >>>>>>>>>>>>>> `crms_customer_requests` WHERE >>>>>>>>>>>>>> `crms_customer_requests`.`arrival_date` >= >>>>>>>>>>>>>> 2021-05-22 GROUP BY `crms_customer_requests`.`arrival_date` >>>>>>>>>>>>>> ORDER BY NULL >>>>>>>>>>>>>> SELECT `crms_customer_requests`.`arrival_date`, >>>>>>>>>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM >>>>>>>>>>>>>> `crms_customer_requests` WHERE >>>>>>>>>>>>>> `crms_customer_requests`.`arrival_date` >= >>>>>>>>>>>>>> 2021-05-23 GROUP BY `crms_customer_requests`.`arrival_date` >>>>>>>>>>>>>> ORDER BY NULL >>>>>>>>>>>>>> SELECT `crms_customer_requests`.`arrival_date`, >>>>>>>>>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM >>>>>>>>>>>>>> `crms_customer_requests` WHERE >>>>>>>>>>>>>> `crms_customer_requests`.`arrival_date` >= >>>>>>>>>>>>>> 2021-05-24 GROUP BY `crms_customer_requests`.`arrival_date` >>>>>>>>>>>>>> ORDER BY NULL >>>>>>>>>>>>>> SELECT `crms_customer_requests`.`arrival_date`, >>>>>>>>>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM >>>>>>>>>>>>>> `crms_customer_requests` WHERE >>>>>>>>>>>>>> `crms_customer_requests`.`arrival_date` >= >>>>>>>>>>>>>> 2021-05-25 GROUP BY `crms_customer_requests`.`arrival_date` >>>>>>>>>>>>>> ORDER BY NULL >>>>>>>>>>>>>> SELECT `crms_customer_requests`.`arrival_date`, >>>>>>>>>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM >>>>>>>>>>>>>> `crms_customer_requests` WHERE >>>>>>>>>>>>>> `crms_customer_requests`.`arrival_date` >= >>>>>>>>>>>>>> 2021-05-26 GROUP BY `crms_customer_requests`.`arrival_date` >>>>>>>>>>>>>> ORDER BY NULL >>>>>>>>>>>>>> SELECT `crms_customer_requests`.`arrival_date`, >>>>>>>>>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM >>>>>>>>>>>>>> `crms_customer_requests` WHERE >>>>>>>>>>>>>> `crms_customer_requests`.`arrival_date` >= >>>>>>>>>>>>>> 2021-05-27 GROUP BY `crms_customer_requests`.`arrival_date` >>>>>>>>>>>>>> ORDER BY NULL >>>>>>>>>>>>>> SELECT `crms_customer_requests`.`arrival_date`, >>>>>>>>>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM >>>>>>>>>>>>>> `crms_customer_requests` WHERE >>>>>>>>>>>>>> `crms_customer_requests`.`arrival_date` >= >>>>>>>>>>>>>> 2021-05-28 GROUP BY `crms_customer_requests`.`arrival_date` >>>>>>>>>>>>>> ORDER BY NULL >>>>>>>>>>>>>> SELECT `crms_customer_requests`.`arrival_date`, >>>>>>>>>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM >>>>>>>>>>>>>> `crms_customer_requests` WHERE >>>>>>>>>>>>>> `crms_customer_requests`.`arrival_date` >= >>>>>>>>>>>>>> 2021-05-29 GROUP BY `crms_customer_requests`.`arrival_date` >>>>>>>>>>>>>> ORDER BY NULL >>>>>>>>>>>>>> SELECT `crms_customer_requests`.`arrival_date`, >>>>>>>>>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM >>>>>>>>>>>>>> `crms_customer_requests` WHERE >>>>>>>>>>>>>> `crms_customer_requests`.`arrival_date` >= >>>>>>>>>>>>>> 2021-05-30 GROUP BY `crms_customer_requests`.`arrival_date` >>>>>>>>>>>>>> ORDER BY NULL >>>>>>>>>>>>>> SELECT `crms_customer_requests`.`arrival_date`, >>>>>>>>>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM >>>>>>>>>>>>>> `crms_customer_requests` WHERE >>>>>>>>>>>>>> `crms_customer_requests`.`arrival_date` >= >>>>>>>>>>>>>> 2021-05-31 GROUP BY `crms_customer_requests`.`arrival_date` >>>>>>>>>>>>>> ORDER BY NULL >>>>>>>>>>>>>> SELECT `crms_customer_requests`.`arrival_date`, >>>>>>>>>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM >>>>>>>>>>>>>> `crms_customer_requests` WHERE >>>>>>>>>>>>>> `crms_customer_requests`.`arrival_date` >= >>>>>>>>>>>>>> 2021-06-01 GROUP BY `crms_customer_requests`.`arrival_date` >>>>>>>>>>>>>> ORDER BY NULL >>>>>>>>>>>>>> SELECT `crms_customer_requests`.`arrival_date`, >>>>>>>>>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM >>>>>>>>>>>>>> `crms_customer_requests` WHERE >>>>>>>>>>>>>> `crms_customer_requests`.`arrival_date` >= >>>>>>>>>>>>>> 2021-06-02 GROUP BY `crms_customer_requests`.`arrival_date` >>>>>>>>>>>>>> ORDER BY NULL >>>>>>>>>>>>>> >>>>>>>>>>>>>> On Wed, 2 Jun 2021 at 21:53, Sebastian Jung < >>>>>>>>>>>>>> [email protected]> wrote: >>>>>>>>>>>>>> >>>>>>>>>>>>>>> Hi Eugene, >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> Please make Print(report.query) then you get SQL querys and >>>>>>>>>>>>>>> Most of time i get an Idea what's wrong >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> Regards >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> Eugene TUYIZERE <[email protected]> schrieb am Mi., 2. >>>>>>>>>>>>>>> Juni 2021, 21:41: >>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> Dear Team, >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> I need help. I am working on a project where one of the >>>>>>>>>>>>>>>> tables is about requests. I want to have a report of the >>>>>>>>>>>>>>>> number of requests >>>>>>>>>>>>>>>> on each day in the last 30 days, something like this: >>>>>>>>>>>>>>>> [image: image.png]I I used the code below just before >>>>>>>>>>>>>>>> displaying on the chart but the code gives me wrong information >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> def reqChart(request): >>>>>>>>>>>>>>>> current_date = date.today() >>>>>>>>>>>>>>>> days_before = date.today()-timedelta(days=30) >>>>>>>>>>>>>>>> for dt in daterange(days_before,current_date): >>>>>>>>>>>>>>>> reports = Customer_Requests.objects.filter( >>>>>>>>>>>>>>>> arrival_date__gte=dt).\ >>>>>>>>>>>>>>>> extra({'day':"date(arrival_date)"}).\ >>>>>>>>>>>>>>>> values('arrival_date').annotate(count=Count('request_name' >>>>>>>>>>>>>>>> )) >>>>>>>>>>>>>>>> print(reports) >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> And I need help >>>>>>>>>>>>>>>> -- >>>>>>>>>>>>>>>> *TUYIZERE Eugene* >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> *Msc Degree in Mathematical Science* >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> *African Institute for Mathematical Sciences (AIMS >>>>>>>>>>>>>>>> Cameroon)Crystal Garden-Lime, Cameroon* >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> Bsc in Computer Science >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> *UR-Nyagatare Campus* >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> Email: [email protected] >>>>>>>>>>>>>>>> [email protected] >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> Tel: (+250) 7 88 26 33 38, (+250) 7 22 26 33 38 >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> -- >>>>>>>>>>>>>>>> You received this message because you are subscribed to the >>>>>>>>>>>>>>>> Google Groups "Django users" group. >>>>>>>>>>>>>>>> To unsubscribe from this group and stop receiving emails >>>>>>>>>>>>>>>> from it, send an email to [email protected]. >>>>>>>>>>>>>>>> To view this discussion on the web visit >>>>>>>>>>>>>>>> https://groups.google.com/d/msgid/django-users/CABxpZHstWyfMVKQhJb%3DxGKff3p3V%2BFQ_w3DkYVpOe-pEW2ySKg%40mail.gmail.com >>>>>>>>>>>>>>>> <https://groups.google.com/d/msgid/django-users/CABxpZHstWyfMVKQhJb%3DxGKff3p3V%2BFQ_w3DkYVpOe-pEW2ySKg%40mail.gmail.com?utm_medium=email&utm_source=footer> >>>>>>>>>>>>>>>> . >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>> -- >>>>>>>>>>>>>>> You received this message because you are subscribed to the >>>>>>>>>>>>>>> Google Groups "Django users" group. >>>>>>>>>>>>>>> To unsubscribe from this group and stop receiving emails >>>>>>>>>>>>>>> from it, send an email to [email protected]. >>>>>>>>>>>>>>> To view this discussion on the web visit >>>>>>>>>>>>>>> https://groups.google.com/d/msgid/django-users/CAKGT9myp4HU6%2BZo6d-JqeaTPsevFBMi_DzU_xuwo3LUja%3DxzRw%40mail.gmail.com >>>>>>>>>>>>>>> <https://groups.google.com/d/msgid/django-users/CAKGT9myp4HU6%2BZo6d-JqeaTPsevFBMi_DzU_xuwo3LUja%3DxzRw%40mail.gmail.com?utm_medium=email&utm_source=footer> >>>>>>>>>>>>>>> . >>>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> -- >>>>>>>>>>>>>> *TUYIZERE Eugene* >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> *Msc Degree in Mathematical Science* >>>>>>>>>>>>>> >>>>>>>>>>>>>> *African Institute for Mathematical Sciences (AIMS >>>>>>>>>>>>>> Cameroon)Crystal Garden-Lime, Cameroon* >>>>>>>>>>>>>> >>>>>>>>>>>>>> Bsc in Computer Science >>>>>>>>>>>>>> >>>>>>>>>>>>>> *UR-Nyagatare Campus* >>>>>>>>>>>>>> >>>>>>>>>>>>>> Email: [email protected] >>>>>>>>>>>>>> [email protected] >>>>>>>>>>>>>> >>>>>>>>>>>>>> Tel: (+250) 7 88 26 33 38, (+250) 7 22 26 33 38 >>>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> -- >>>>>>>>>>>>> *TUYIZERE Eugene* >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> *Msc Degree in Mathematical Science* >>>>>>>>>>>>> >>>>>>>>>>>>> *African Institute for Mathematical Sciences (AIMS >>>>>>>>>>>>> Cameroon)Crystal Garden-Lime, Cameroon* >>>>>>>>>>>>> >>>>>>>>>>>>> Bsc in Computer Science >>>>>>>>>>>>> >>>>>>>>>>>>> *UR-Nyagatare Campus* >>>>>>>>>>>>> >>>>>>>>>>>>> Email: [email protected] >>>>>>>>>>>>> [email protected] >>>>>>>>>>>>> >>>>>>>>>>>>> Tel: (+250) 7 88 26 33 38, (+250) 7 22 26 33 38 >>>>>>>>>>>>> >>>>>>>>>>>>> -- >>>>>>>>>>>>> You received this message because you are subscribed to the >>>>>>>>>>>>> Google Groups "Django users" group. >>>>>>>>>>>>> To unsubscribe from this group and stop receiving emails from >>>>>>>>>>>>> it, send an email to [email protected]. >>>>>>>>>>>>> To view this discussion on the web visit >>>>>>>>>>>>> https://groups.google.com/d/msgid/django-users/CABxpZHtJhxd3-B%3DpzsAhqg_kR68zTvbJKd%2BgeBUqRjGMP%2BxgxQ%40mail.gmail.com >>>>>>>>>>>>> <https://groups.google.com/d/msgid/django-users/CABxpZHtJhxd3-B%3DpzsAhqg_kR68zTvbJKd%2BgeBUqRjGMP%2BxgxQ%40mail.gmail.com?utm_medium=email&utm_source=footer> >>>>>>>>>>>>> . >>>>>>>>>>>>> >>>>>>>>>>>> -- >>>>>>>>>>>> You received this message because you are subscribed to the >>>>>>>>>>>> Google Groups "Django users" group. >>>>>>>>>>>> To unsubscribe from this group and stop receiving emails from >>>>>>>>>>>> it, send an email to [email protected]. >>>>>>>>>>>> To view this discussion on the web visit >>>>>>>>>>>> https://groups.google.com/d/msgid/django-users/CAGp2JVGM87kRnp%2BZY_J8fKb2d_mU5Vvxv033oQSZ-ChHAeiFCA%40mail.gmail.com >>>>>>>>>>>> <https://groups.google.com/d/msgid/django-users/CAGp2JVGM87kRnp%2BZY_J8fKb2d_mU5Vvxv033oQSZ-ChHAeiFCA%40mail.gmail.com?utm_medium=email&utm_source=footer> >>>>>>>>>>>> . >>>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> -- >>>>>>>>>>> *TUYIZERE Eugene* >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> *Msc Degree in Mathematical Science* >>>>>>>>>>> >>>>>>>>>>> *African Institute for Mathematical Sciences (AIMS >>>>>>>>>>> Cameroon)Crystal Garden-Lime, Cameroon* >>>>>>>>>>> >>>>>>>>>>> Bsc in Computer Science >>>>>>>>>>> >>>>>>>>>>> *UR-Nyagatare Campus* >>>>>>>>>>> >>>>>>>>>>> Email: [email protected] >>>>>>>>>>> [email protected] >>>>>>>>>>> >>>>>>>>>>> Tel: (+250) 7 88 26 33 38, (+250) 7 22 26 33 38 >>>>>>>>>>> >>>>>>>>>>> -- >>>>>>>>>>> You received this message because you are subscribed to the >>>>>>>>>>> Google Groups "Django users" group. >>>>>>>>>>> To unsubscribe from this group and stop receiving emails from >>>>>>>>>>> it, send an email to [email protected]. >>>>>>>>>>> >>>>>>>>>> To view this discussion on the web visit >>>>>>>>>>> https://groups.google.com/d/msgid/django-users/CABxpZHviuVHHqyod0f5miLA1Z2n73P%2B3xXWOs-7XLmi2epD-7w%40mail.gmail.com >>>>>>>>>>> <https://groups.google.com/d/msgid/django-users/CABxpZHviuVHHqyod0f5miLA1Z2n73P%2B3xXWOs-7XLmi2epD-7w%40mail.gmail.com?utm_medium=email&utm_source=footer> >>>>>>>>>>> . >>>>>>>>>>> >>>>>>>>>> -- >>>>>>>>> You received this message because you are subscribed to the Google >>>>>>>>> Groups "Django users" group. >>>>>>>>> To unsubscribe from this group and stop receiving emails from it, >>>>>>>>> send an email to [email protected]. >>>>>>>>> >>>>>>>> To view this discussion on the web visit >>>>>>>>> https://groups.google.com/d/msgid/django-users/85a1d671-d5c9-4f97-9f34-b6f1e1b36bcfn%40googlegroups.com >>>>>>>>> <https://groups.google.com/d/msgid/django-users/85a1d671-d5c9-4f97-9f34-b6f1e1b36bcfn%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>>>>>> . >>>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> -- >>>>>>>> *TUYIZERE Eugene* >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> *Msc Degree in Mathematical Science* >>>>>>>> >>>>>>>> *African Institute for Mathematical Sciences (AIMS Cameroon)Crystal >>>>>>>> Garden-Lime, Cameroon* >>>>>>>> >>>>>>>> Bsc in Computer Science >>>>>>>> >>>>>>>> *UR-Nyagatare Campus* >>>>>>>> >>>>>>>> Email: [email protected] >>>>>>>> [email protected] >>>>>>>> >>>>>>>> Tel: (+250) 7 88 26 33 38, (+250) 7 22 26 33 38 >>>>>>>> >>>>>>> -- >>>>>>> You received this message because you are subscribed to the Google >>>>>>> Groups "Django users" group. >>>>>>> To unsubscribe from this group and stop receiving emails from it, >>>>>>> send an email to [email protected]. >>>>>>> To view this discussion on the web visit >>>>>>> https://groups.google.com/d/msgid/django-users/63a82f60-e533-41f5-b1e9-0159b37b58b0n%40googlegroups.com >>>>>>> <https://groups.google.com/d/msgid/django-users/63a82f60-e533-41f5-b1e9-0159b37b58b0n%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>>>> . >>>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> *TUYIZERE Eugene* >>>>>> >>>>>> >>>>>> >>>>>> *Msc Degree in Mathematical Science* >>>>>> >>>>>> *African Institute for Mathematical Sciences (AIMS Cameroon)Crystal >>>>>> Garden-Lime, Cameroon* >>>>>> >>>>>> Bsc in Computer Science >>>>>> >>>>>> *UR-Nyagatare Campus* >>>>>> >>>>>> Email: [email protected] >>>>>> [email protected] >>>>>> >>>>>> Tel: (+250) 7 88 26 33 38, (+250) 7 22 26 33 38 >>>>>> >>>>>> -- >>>>>> You received this message because you are subscribed to the Google >>>>>> Groups "Django users" group. >>>>>> To unsubscribe from this group and stop receiving emails from it, >>>>>> send an email to [email protected]. >>>>>> To view this discussion on the web visit >>>>>> https://groups.google.com/d/msgid/django-users/CABxpZHsJVbdpwEwpp-_kM3PN6xZ59reCvbJbzMgE_2pSxMeiRA%40mail.gmail.com >>>>>> <https://groups.google.com/d/msgid/django-users/CABxpZHsJVbdpwEwpp-_kM3PN6xZ59reCvbJbzMgE_2pSxMeiRA%40mail.gmail.com?utm_medium=email&utm_source=footer> >>>>>> . >>>>>> >>>>> -- >>>>> You received this message because you are subscribed to the Google >>>>> Groups "Django users" group. >>>>> To unsubscribe from this group and stop receiving emails from it, send >>>>> an email to [email protected]. >>>>> To view this discussion on the web visit >>>>> https://groups.google.com/d/msgid/django-users/CAGp2JVHmjfN3_KFB9eMk%2BzMtii9QeDy4dL1qFKMT%2BRVjQOFrFA%40mail.gmail.com >>>>> <https://groups.google.com/d/msgid/django-users/CAGp2JVHmjfN3_KFB9eMk%2BzMtii9QeDy4dL1qFKMT%2BRVjQOFrFA%40mail.gmail.com?utm_medium=email&utm_source=footer> >>>>> . >>>>> >>>> >>>> >>>> -- >>>> *TUYIZERE Eugene* >>>> >>>> >>>> >>>> *Msc Degree in Mathematical Science* >>>> >>>> *African Institute for Mathematical Sciences (AIMS Cameroon)Crystal >>>> Garden-Lime, Cameroon* >>>> >>>> Bsc in Computer Science >>>> >>>> *UR-Nyagatare Campus* >>>> >>>> Email: [email protected] >>>> [email protected] >>>> >>>> Tel: (+250) 7 88 26 33 38, (+250) 7 22 26 33 38 >>>> >>>> -- >>>> You received this message because you are subscribed to the Google >>>> Groups "Django users" group. >>>> To unsubscribe from this group and stop receiving emails from it, send >>>> an email to [email protected]. >>>> To view this discussion on the web visit >>>> https://groups.google.com/d/msgid/django-users/CABxpZHuvFye2tB2rSS_uWB4g2DXAjLTG2i0zvzO1rDpdqJtvNQ%40mail.gmail.com >>>> <https://groups.google.com/d/msgid/django-users/CABxpZHuvFye2tB2rSS_uWB4g2DXAjLTG2i0zvzO1rDpdqJtvNQ%40mail.gmail.com?utm_medium=email&utm_source=footer> >>>> . >>>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "Django users" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to [email protected]. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/django-users/CAGp2JVGh3zGsJ%2BtwRqKYxdoUEo3-Pr72uHC7B8LZRPbQm%3DHwQQ%40mail.gmail.com >>> <https://groups.google.com/d/msgid/django-users/CAGp2JVGh3zGsJ%2BtwRqKYxdoUEo3-Pr72uHC7B8LZRPbQm%3DHwQQ%40mail.gmail.com?utm_medium=email&utm_source=footer> >>> . >>> >> >> >> -- >> *TUYIZERE Eugene* >> >> >> >> *Msc Degree in Mathematical Science* >> >> *African Institute for Mathematical Sciences (AIMS Cameroon)Crystal >> Garden-Lime, Cameroon* >> >> Bsc in Computer Science >> >> *UR-Nyagatare Campus* >> >> Email: [email protected] >> [email protected] >> >> Tel: (+250) 7 88 26 33 38, (+250) 7 22 26 33 38 >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Django users" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/django-users/CABxpZHsFtuHWY0rJuxfPOteAUZuPG%2BJ3G-av%3DSeP8DiWYAs6kw%40mail.gmail.com >> <https://groups.google.com/d/msgid/django-users/CABxpZHsFtuHWY0rJuxfPOteAUZuPG%2BJ3G-av%3DSeP8DiWYAs6kw%40mail.gmail.com?utm_medium=email&utm_source=footer> >> . >> > -- > You received this message because you are subscribed to the Google Groups > "Django users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/django-users/CAGp2JVHSq%3DC2wyp%3D8arnm1xn1BkuU53nb6J2YyW%2BFwYBnB9UNA%40mail.gmail.com > <https://groups.google.com/d/msgid/django-users/CAGp2JVHSq%3DC2wyp%3D8arnm1xn1BkuU53nb6J2YyW%2BFwYBnB9UNA%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > -- *TUYIZERE Eugene* *Msc Degree in Mathematical Science* *African Institute for Mathematical Sciences (AIMS Cameroon)Crystal Garden-Lime, Cameroon* Bsc in Computer Science *UR-Nyagatare Campus* Email: [email protected] [email protected] Tel: (+250) 7 88 26 33 38, (+250) 7 22 26 33 38 -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CABxpZHtM-tgH77BN%3DHa5zyHgkR8APBU5%3DVHu4TFKYe6_PRSeRQ%40mail.gmail.com.
