# filter by month inside views dictionary
**URL:** https://forum.djangoproject.com/t/filter-by-month-inside-views-dictionary/13749
**Category:** Using the ORM
**Created:** [May 17, 2022, 6:38am UTC](https://forum.djangoproject.com/t/filter-by-month-inside-views-dictionary/13749 "2022-05-17T06:38:03Z")
**Posts on this page:** 20
**Page:** 1
### Author:  [@itsjamaal](https://forum.djangoproject.com/u/itsjamaal)
#### Post date: [May 17, 2022, 6:38am UTC](https://forum.djangoproject.com/t/filter-by-month-inside-views-dictionary/13749/1 "2022-05-17T06:38:03Z")
```auto
def testing(request):
totals_dict = {
'Eating': Daily.objects.aggregate(eats=Sum('transamount', filter=Q(transcategory_id=5) & Q(transdate__month=1) | Q(transcategory_id=19) & Q(transdate__month=1) | Q(transcategory_id=20) & Q(transdate__month=1) | Q(transcategory_id=28) & Q(transdate__month=1) | Q(transcategory_id=31) & Q(transdate__month=1)))['eats'],
'Trans_List': Daily.objects.all(),
'Total_Bal': Daily.objects.all().aggregate(tb=Sum('transamount'))['tb'],
'Cash_Bal': Daily.objects.aggregate(CashBAL=Sum('transamount', filter=Q(transmode__name='Cash')))['CashBAL'],
'Enbd_Bal': Daily.objects.aggregate(ENBDBAL=Sum('transamount', filter=Q(transmode__name='ENBD')))['ENBDBAL'],
'NoL_Bal': Daily.objects.aggregate(NoLBAL=Sum('transamount', filter=Q(transmode__name='NoL')))['NoLBAL'],
'PayIT_Bal': Daily.objects.aggregate(PayITBAL=Sum('transamount', filter=Q(transmode__name='Pay IT')))[
'PayITBAL'],
'Sib_Bal': Daily.objects.aggregate(SibBAL=Sum('transamount', filter=Q(transmode__name='SIB')))['SibBAL'],
}
return render(request, 'testing.html', totals_dict)
```
In my above ‘view’, I am getting correct result for ‘Eating’ but I have hardcoded the month as ‘1’, so it’s 'Sum’ming only for January.
Please guide me to make every ‘Sum’ based on months.
Is it possible to create the dict values inside a loop like
```auto
"for i in 1 to 12 "
```
---
### Author:  [@adiraijamal](https://forum.djangoproject.com/u/adiraijamal)
#### Post date: [March 2, 2023, 4:35am UTC](https://forum.djangoproject.com/t/filter-by-month-inside-views-dictionary/13749/2 "2023-03-02T04:35:22Z")
After a very long time, I am back here.
Please guide me.
---
### Author:  [@KenWhitesell](https://forum.djangoproject.com/u/KenWhitesell)
#### Post date: [March 2, 2023, 1:07pm UTC](https://forum.djangoproject.com/t/filter-by-month-inside-views-dictionary/13749/3 "2023-03-02T13:07:20Z")
So it’s not clear exactly what you’re looking for here. What do you want the final data structure to look like?
Are you looking for one value `totals_dict['Eating']` that has the sum for all the entries `transdate__month` from 1 to 12?
Or are you looking for a list such that `totals_dict['Eating'][0]` is the sum for `transdate__month=1` through `totals_dict['Eating'][11]` is the sum for `transdate__month=12`?
Or are you looking for some other data structure?
---
### Author:  [@adiraijamal](https://forum.djangoproject.com/u/adiraijamal)
#### Post date: [March 3, 2023, 4:09am UTC](https://forum.djangoproject.com/t/filter-by-month-inside-views-dictionary/13749/4 "2023-03-03T04:09:19Z")
* * *
Looking for one value `totals_dict['Eating']` that has the sum for all the entries `transdate__month` from 1 to 12?
## This is what I am looking for. Report ( eating ) should be for each month as a sum.
```auto
'Eating': Daily.objects.aggregate(eats=Sum('transamount', filter=Q(transcategory_id=5) & Q(transdate__month=1) | Q(transcategory_id=19) & Q(transdate__month=1) | Q(transcategory_id=20) & Q(transdate__month=1) | Q(transcategory_id=28) & Q(transdate__month=1) | Q(transcategory_id=31) & Q(transdate__month=1)))['eats'],
```
Here I have hard corded transdate\_\_month as 1 (Jan)
I want to loop it for every month.
---
### Author:  [@adiraijamal](https://forum.djangoproject.com/u/adiraijamal)
#### Post date: [March 3, 2023, 5:00am UTC](https://forum.djangoproject.com/t/filter-by-month-inside-views-dictionary/13749/5 "2023-03-03T05:00:20Z")
```auto
exec("for i in range(12): print(Daily.objects.aggregate(alias=Sum('transamount', filter=Q(transdate__month=i+1) & Q(transmode__name='Cash'))))")
{'alias': Decimal('99.25')}
{'alias': Decimal('161.25')}
{'alias': Decimal('239')}
{'alias': None}
{'alias': None}
{'alias': None}
{'alias': None}
{'alias': None}
{'alias': None}
{'alias': None}
{'alias': None}
{'alias': None}
```
…
In python shell above is bringing the required results
but in views …
…
```auto
def bymonth(request):
for x in range(12):
print(Daily.objects.aggregate(mjc=Sum('transamount', filter=Q(transdate__month=[x+1]) & Q(transmode__name='Cash'))))['mjc']
totals_dict = {
'Total_Bal': Daily.objects.all().aggregate(tb=Sum('transamount'))['tb'],
'Cash_Bal': Daily.objects.aggregate(CashBAL=Sum('transamount', filter=Q(transmode__name='Cash')))['CashBAL'],
'Enbd_Bal': Daily.objects.aggregate(ENBDBAL=Sum('transamount', filter=Q(transmode__name='ENBD')))['ENBDBAL'],
'NoL_Bal': Daily.objects.aggregate(NoLBAL=Sum('transamount', filter=Q(transmode__name='NoL')))['NoLBAL'],
'PayIT_Bal': Daily.objects.aggregate(PayITBAL=Sum('transamount', filter=Q(transmode__name='Pay IT')))['PayITBAL'],
'Sib_Bal': Daily.objects.aggregate(SibBAL=Sum('transamount', filter=Q(transmode__name='SIB')))['SibBAL'],
'monthsd': monjc
}
return render(request, 'bymonth.html', totals_dict)
```
## While running the above , I am getting the below error
| Request Method: | GET |
| --- | --- |
| Request URL: | [http://127.0.0.1:8000/bymonth](http://127.0.0.1:8000/bymonth) |
| Django Version: | 4.1.7 |
| Exception Type: | TypeError |
| Exception Value: | Field ‘None’ expected a number but got [1]. |
* * *
---
### Author:  [@adiraijamal](https://forum.djangoproject.com/u/adiraijamal)
#### Post date: [March 3, 2023, 6:10am UTC](https://forum.djangoproject.com/t/filter-by-month-inside-views-dictionary/13749/6 "2023-03-03T06:10:31Z")
[quote=“KenWhitesell, post:3, topic:13749”]
are you looking for a list such that `totals_dict['Eating'][0]` is the sum for
```auto
`transdate__month=1` through `totals_dict['Eating'][11]` is the sum for `transdate__month=12`?
```
Exactly as above.
---
### Author:  [@KenWhitesell](https://forum.djangoproject.com/u/KenWhitesell)
#### Post date: [March 3, 2023, 12:28pm UTC](https://forum.djangoproject.com/t/filter-by-month-inside-views-dictionary/13749/7 "2023-03-03T12:28:29Z")
Ok, first I’m going to simplify this:
> [@itsjamaal](#):
>
> ```auto
> 'Eating': Daily.objects.aggregate(eats=Sum('transamount', filter=Q(transcategory_id=5) & Q(transdate__month=1) | Q(transcategory_id=19) & Q(transdate__month=1) | Q(transcategory_id=20) & Q(transdate__month=1) | Q(transcategory_id=28) & Q(transdate__month=1) | Q(transcategory_id=31) & Q(transdate__month=1)))['eats'],
>
> ```
To this:
```auto
'Eating': Daily.objects.aggregate(
eats=Sum('transamount',
filter=Q(transcategory_id__in=[5, 19, 20, 28, 31], transdate__month=1)
)['eats'],
```
Now, we’ll wrap that in a list comprehension to iterate over the months:
```auto
'Eating': [
Daily.objects.aggregate(eats=Sum('transamount',
filter=Q(transcategory_id__in=[5, 19, 20, 28, 31], transdate__month=month)
)['eats']
for month in range(1,13)
],
```
---
### Author:  [@adiraijamal](https://forum.djangoproject.com/u/adiraijamal)
#### Post date: [March 6, 2023, 4:10am UTC](https://forum.djangoproject.com/t/filter-by-month-inside-views-dictionary/13749/8 "2023-03-06T04:10:06Z")
wow! that’s great.
I will apply this and check.
Thanks a lot.
---
### Author:  [@adiraijamal](https://forum.djangoproject.com/u/adiraijamal)
#### Post date: [March 6, 2023, 4:49am UTC](https://forum.djangoproject.com/t/filter-by-month-inside-views-dictionary/13749/9 "2023-03-06T04:49:07Z")
```auto
def bymonth(request):
totals_dict = {
'Total_Bal': Daily.objects.all().aggregate(tb=Sum('transamount'))['tb'],
'Cash_Bal': Daily.objects.aggregate(CashBAL=Sum('transamount', filter=Q(transmode__name='Cash')))['CashBAL'],
'Enbd_Bal': Daily.objects.aggregate(ENBDBAL=Sum('transamount', filter=Q(transmode__name='ENBD')))['ENBDBAL'],
'NoL_Bal': Daily.objects.aggregate(NoLBAL=Sum('transamount', filter=Q(transmode__name='NoL')))['NoLBAL'],
'PayIT_Bal': Daily.objects.aggregate(PayITBAL=Sum('transamount', filter=Q(transmode__name='Pay IT')))[
'PayITBAL'],
'Sib_Bal': Daily.objects.aggregate(SibBAL=Sum('transamount', filter=Q(transmode__name='SIB')))['SibBAL'],
'Eating': [Daily.objects.aggregate(
eats=Sum('transamount', filter=Q(transcategory_id__in=[5, 19, 20, 28, 31], transdate__month=month))['eats']
for month in range(1, 13))
],
}
return render(request, 'bymonth.html', totals_dict)
```
My bymonth.html
```auto
{% extends 'base.html' %}
{% block content %}
Testing Place
Total Balance : {{ Total_Bal|floatformat:'2g' }}
Cash Balance : {{ Cash_Bal |floatformat:'2g'}}
Enbd Balance : {{ Enbd_Bal |floatformat:'2g'}}
NoL Balance : {{ NoL_Bal|floatformat:'2g' }}
Pay IT Balance : {{ PayIT_Bal|floatformat:'2g' }}
Sib Balance : {{ Sib_Bal|floatformat:'2g'}}
Eating : {{ Eating }}
```
But I am getting error
…
File “D:\Learn\Expenses\dailytrans\views.py”, line 41
eats=Sum(‘transamount’, filter=Q(transcategory\_id\_\_in=[5, 19, 20, 28, 31], transdate\_\_month=month))[‘eats’]
^^^^^
SyntaxError: invalid syntax. Maybe you meant ‘==’ or ‘:=’ instead of ‘=’?
…
---
### Author:  [@KenWhitesell](https://forum.djangoproject.com/u/KenWhitesell)
#### Post date: [March 6, 2023, 11:39am UTC](https://forum.djangoproject.com/t/filter-by-month-inside-views-dictionary/13749/10 "2023-03-06T11:39:36Z")
Missing paren - there should be one more paren (three in total) after the `transdate__month=month` clause.
And you’ve got an extra paren after the `for month in range` clause.
---
### Author:  [@adiraijamal](https://forum.djangoproject.com/u/adiraijamal)
#### Post date: [March 7, 2023, 4:39am UTC](https://forum.djangoproject.com/t/filter-by-month-inside-views-dictionary/13749/11 "2023-03-07T04:39:27Z")
Thanks, That started working now. Need some more improvement.
```auto
totals_dict = {
'Total_Bal': [Daily.objects.all().aggregate(tb=Sum('transamount', filter=Q(transdate__month=month)))['tb']
for month in range(1, 13)
],
'Cash_Bal': [Daily.objects.aggregate(
CashBAL=Sum('transamount', filter=Q(transmode __name='Cash', transdate__ month=month)))['CashBAL']
for month in range(1, 13)
],
'Enbd_Bal': [Daily.objects.aggregate(
ENBDBAL=Sum('transamount', filter=Q(transmode __name='ENBD', transdate__ month=month)))['ENBDBAL']
for month in range(1, 13)
],
'Eating': [Daily.objects.aggregate(
eats=Sum('transamount', filter=Q(transcategory_id__in=[5, 19, 20, 28, 31], transdate__month=month)))['eats']
for month in range(1, 13)
],
}
return render(request, 'alltrans.html', totals_dict)
```
and my HTML is
```auto
{% extends 'base.html' %}
{% block content %}
Testing Place
Total Balance : {{ Total_Bal }}
Cash Balance : {{ Cash_Bal }}
Enbd Balance : {{ Enbd_Bal }}
Eating : {{ Eating }}
{% endblock %}
```
And my result is
```auto
Total Balance : [Decimal('2630.36000000000'), Decimal('1575.66000000000'), Decimal('120.75'), None, None, None, None, None, None, None, None, None]
Cash Balance : [Decimal('99.25'), Decimal('161.25'), Decimal('200'), None, None, None, None, None, None, None, None, None]
Enbd Balance : [Decimal('2215.72000000000'), Decimal('1361.66000000000'), Decimal('-59.25'), None, None, None, None, None, None, None, None, None]
Eating : [Decimal('-1623.06000000000'), Decimal('-2410.03000000000'), Decimal('-11.25'), None, None, None, None, None, None, None, None, None]
```
I want to avoid **“None”**.
Only the months which is having data should be in the result.
---
### Author:  [@KenWhitesell](https://forum.djangoproject.com/u/KenWhitesell)
#### Post date: [March 7, 2023, 4:59am UTC](https://forum.djangoproject.com/t/filter-by-month-inside-views-dictionary/13749/12 "2023-03-07T04:59:13Z")
Actually, no, that would be a mistake. If you remove the None results, how can you tell which months you have?
What you probably want to do is either replace that none with a different value such as a blank string or a value of zero, or possibly handle that situation in your template.
---
### Author:  [@adiraijamal](https://forum.djangoproject.com/u/adiraijamal)
#### Post date: [March 7, 2023, 5:11am UTC](https://forum.djangoproject.com/t/filter-by-month-inside-views-dictionary/13749/13 "2023-03-07T05:11:19Z")
Agreed. Will play in template.
---
### Author:  [@adiraijamal](https://forum.djangoproject.com/u/adiraijamal)
#### Post date: [March 7, 2023, 5:14am UTC](https://forum.djangoproject.com/t/filter-by-month-inside-views-dictionary/13749/14 "2023-03-07T05:14:48Z")
How to bring the values in the template by month.
```auto
|
Jan |
Feb |
Mar |
Apr |
May |
Jun |
Jul |
Aug |
Sep |
Oct |
Nov |
Dec |
| Cash |
{{ Cash_Bal }} |
feb cash |
| ENBD |
{{ Enbd_Bal }} |
feb bd |
| NoL |
| Pay IT |
| SIB |
```
My template is as above
---
### Author:  [@KenWhitesell](https://forum.djangoproject.com/u/KenWhitesell)
#### Post date: [March 7, 2023, 1:39pm UTC](https://forum.djangoproject.com/t/filter-by-month-inside-views-dictionary/13749/15 "2023-03-07T13:39:18Z")
See [Built-in template tags and filters | Django documentation | Django](https://docs.djangoproject.com/en/4.1/ref/templates/builtins/#for)
---
### Author:  [@adiraijamal](https://forum.djangoproject.com/u/adiraijamal)
#### Post date: [March 9, 2023, 6:14am UTC](https://forum.djangoproject.com/t/filter-by-month-inside-views-dictionary/13749/16 "2023-03-09T06:14:34Z")
```auto
def alltrans(request):
x = len(Daily.objects.values('transdate__month').distinct())+1
totals_dict = dict(title='Alltrans', Total_Bal=[
Daily.objects.all().aggregate(tb=Sum('transamount', filter=Q(transdate__month=month)))['tb']
for month in range(1, x)
], Cash_Bal=[
Daily.objects.aggregate(CashBAL=Sum('transamount', filter=Q(transmode __name='Cash', transdate__ month=month)))[
'CashBAL']
for month in range(1, x)
], Enbd_Bal=[
Daily.objects.aggregate(ENBDBAL=Sum('transamount', filter=Q(transmode __name='ENBD', transdate__ month=month)))[
'ENBDBAL']
for month in range(1, x)
], NoL_Bal=[
Daily.objects.aggregate(NoLBAL=Sum('transamount', filter=Q(transmode __name='NoL', transdate__ month=month)))[
'NoLBAL']
for month in range(1, x)
], PayIT_Bal=[
Daily.objects.aggregate(PayITBAL=Sum('transamount', filter=Q(transmode __name='PayIT', transdate__ month=month)))[
'PayITBAL']
for month in range(1, x)
], Sib_Bal=[
Daily.objects.aggregate(SibBAL=Sum('transamount', filter=Q(transmode __name='NoL', transdate__ month=month)))[
'SibBAL']
for month in range(1, x)
], Eating=[Daily.objects.aggregate(
eats=Sum('transamount', filter=Q(transcategory_id__in=[5, 19, 20, 28, 31], transdate__month=month)))['eats']
for month in range(1, x)
])
return render(request, 'alltrans.html', totals_dict)
```
I have learned to alter my required result.
And my template is
```auto
{% extends 'base.html' %}
{% block content %}
|
January |
February |
March |
April |
May |
June |
July |
August |
September |
October |
November |
December |
| Cash |
{% for cash in Cash_Bal %}
{{ cash | floatformat:'2g' }} |
{% endfor %}
| ENBD |
{% for enbd in Enbd_Bal %}
{{enbd | floatformat:'2g'}} |
{% endfor %}
| NoL |
{% for nol in NoL_Bal %}
{{ nol | floatformat:'2g'}} |
{% endfor %}
| Pay IT |
{% for payit in PayIT_Bal %}
{{ payit | floatformat:'2g'}} |
{% endfor %}
| SIB |
{% for sib in Sib_Bal %}
{{ sib | floatformat:'2g'}} |
{% endfor %}
{% endblock %}
```
Any my output is
Can I still make improvements in this …
Please suggest.
---
### Author:  [@KenWhitesell](https://forum.djangoproject.com/u/KenWhitesell)
#### Post date: [March 9, 2023, 12:21pm UTC](https://forum.djangoproject.com/t/filter-by-month-inside-views-dictionary/13749/17 "2023-03-09T12:21:04Z")
I’m not sure what all improvements you’d be looking for.
You might want to start looking at some CSS to make all the columns the same width.
---
### Author:  [@adiraijamal](https://forum.djangoproject.com/u/adiraijamal)
#### Post date: [March 9, 2023, 12:25pm UTC](https://forum.djangoproject.com/t/filter-by-month-inside-views-dictionary/13749/18 "2023-03-09T12:25:40Z")
Thanks for your continuous support.
I was thinking about
```auto
totals_dict = dict(title='Alltrans', Total_Bal=[
Daily.objects.all().aggregate(tb=Sum('transamount', filter=Q(transdate__month=month)))['tb']
for month in range(1, x)
], Cash_Bal=[
Daily.objects.aggregate(CashBAL=Sum('transamount', filter=Q(transmode __name='Cash', transdate__ month=month)))[
'CashBAL']
for month in range(1, x)
], Enbd_Bal=[
Daily.objects.aggregate(ENBDBAL=Sum('transamount', filter=Q(transmode __name='ENBD', transdate__ month=month)))[
'ENBDBAL']
for month in range(1, x)
], NoL_Bal=[
Daily.objects.aggregate(NoLBAL=Sum('transamount', filter=Q(transmode __name='NoL', transdate__ month=month)))[
'NoLBAL']
for month in range(1, x)
], PayIT_Bal=[
Daily.objects.aggregate(PayITBAL=Sum('transamount', filter=Q(transmode __name='PayIT', transdate__ month=month)))[
'PayITBAL']
for month in range(1, x)
], Sib_Bal=[
Daily.objects.aggregate(SibBAL=Sum('transamount', filter=Q(transmode __name='NoL', transdate__ month=month)))[
'SibBAL']
for month in range(1, x)
]
```
the “for” loop is repeating the same. Can it be replaced by a single for loop.
---
### Author:  [@KenWhitesell](https://forum.djangoproject.com/u/KenWhitesell)
#### Post date: [March 9, 2023, 12:35pm UTC](https://forum.djangoproject.com/t/filter-by-month-inside-views-dictionary/13749/19 "2023-03-09T12:35:58Z")
Actually, using aggregates and being willing to restructure how you’re collecting the results in your view, this can probably be done without any explicit loops at all.
---
### Author:  [@adiraijamal](https://forum.djangoproject.com/u/adiraijamal)
#### Post date: [March 9, 2023, 12:41pm UTC](https://forum.djangoproject.com/t/filter-by-month-inside-views-dictionary/13749/20 "2023-03-09T12:41:56Z")
Please show me some light on that.
[Next page](https://forum.djangoproject.com/t/filter-by-month-inside-views-dictionary/13749.md?page=2)