Code

Changes between Initial Version and Version 1 of Ticket #11305, comment 12


Ignore:
Timestamp:
09/08/11 17:27:28 (3 years ago)
Author:
crayz_train
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #11305, comment 12

    initial v1  
    11I need the equivalent of sumifs (http://office.microsoft.com/en-us/excel-help/sumifs-function-HA010047504.aspx?CTT=3) and countifs (http://office.microsoft.com/en-us/excel-help/countifs-function-HA010047494.aspx) to replace a report that is currently baked into an excel spreadsheet somewhere. 
    22 
    3 In a nutshell, we have orders which have a quantity of items, a total amount for the order, tax amount, and are related to a specific customer name. I need to output something like this: 
    4 Customer, Total Items (per customer), Total Orders (per customer), Total Amount (per customer), Total Tax (per customer) 
    5 UserA,6,3,$50,$5 
    6 UserB,34,2,$1800,$100 
     3In a nutshell, we have orders which have a quantity of items, a total amount for the order, tax amount, and are related to a specific customer name. I need to output something like this:[[BR]] 
     4Customer, Total Items (per customer), Total Orders (per customer), Total Amount (per customer), Total Tax (per customer)[[BR]] 
     5UserA,6,3,$50,$5[[BR]] 
     6UserB,34,2,$1800,$100[[BR]] 
    77 
    8 I would think this sort of thing to be a very common use case. It can be done to the queryset, but sql is good at this sort of thing, so I think it would be better to be able to generate this type of output as a queryset. I'm proselytizing for the integrating the support for conditional aggregates. I like django much better than Excel, but excel has these tools... 
     8I would think this sort of thing to be a very common use case. It can be done to the queryset, but sql is good at this sort of thing, so I think it would be better to be able to generate this type of output as a queryset via the ORM. I'm debating whether to fall back to raw() for now. 
     9 
     10I'm proselytizing for integration of support for conditional aggregates. I like django much better than Excel, but excel has these tools...