Group by and count values
Sharpless512
Im new to Django.
I have different classes (Stock, Portfolio, Trades)
What Im trying to achieve is a summery of all trades per stock.
So Basicly this is how my rows are now
I want to combine or group by stock_id and do a sum of open_price and quantity.
I tried with
Trade.objects.filter(portfolio=1).values('stock__name').aggregate(stock_total=Count('stock',distinct=True))
But that doesnt work.
How do I need to write the query to get that result?
Astik Anand
Try this:
from django.db.models import Count
Trade.objects.filter(portfolio=1).values('stock__name').annotate(stock_total=Count('entry'))
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
Related
Related Related
- 1
count all values and group by with count
- 2
Sum and count values by group
- 3
Count unique values by group
- 4
Pandas group by column and count values
- 5
MySQL GROUP BY with Zero values in the count
- 6
Count and group on occurrences of keys and their values
- 7
How to count values in pandas group
- 8
Group by count for boolean values in collection
- 9
Running count of repeating values by group
- 10
Count the number of unique values by group
- 11
Count rows by group based on values
- 12
R DPLYR Count Values BY Group
- 13
Count total missing values by group?
- 14
Count distinct values depending on group
- 15
MySQL Group by consecutive values and count
- 16
How to count values in group by with condition?
- 17
Count values that go in row in group?
- 18
TSQL Count appearance Group by values in other table
- 19
SQLite Count of Values in 1 Column and Group By ID
- 20
SQL query to get count and group by output values
- 21
group by and count values from text field
- 22
Find values with group count greater than 1
- 23
How to add default values to group by & count in PostgreSQL?
- 24
Limiting GROUP BY based on COUNT() values in mySQL
- 25
Prometheus Query - Group by values and return a count
- 26
How to count number of values per group?
- 27
Add new column for count of repeated group values
- 28
How to group by and count values in my DataFrame?
- 29
SQL GROUP BY COUNT and Include 0 Values
Comments