Group By

    Let's start aggregating and computing values for groups of data in our report model.

    This an example of "Total Sales Of Each Product"
    

class GroupByIntro(SlickReportView):
    
    report_model = SalesLineTransaction
    date_field = 'transaction_date'

    group_by = 'product'
    # We can group_by a foreign key or date field

    columns = ['name',
               SlickReportField.create(method=Sum, field='value', name='value__sum', verbose_name=_('Total sold $'))
               # a Slick Report Field is responsible for carrying on the needed calculation(s).
               ]

                

---

Live Example

Filters

From date

To date

Client

Client 0 Client 1 Client 2 Client 3 Client 4 Client 5 Client 6 Client 7 Client 8 Client 9

Product

Product 0 Product 1 Product 2 Product 3 Product 4 Product 5 Product 6 Product 7 Product 8 Product 9

Results