[GitHub] [superset] jgarcia-74 opened a new issue #18088: Aggregation in Pivot Table 2 component needs to happen by column and not one type of aggregation for all metrics.

[GitBox <gi...@apache.org>]

jgarcia-74 opened a new issue #18088:
URL: https://github.com/apache/superset/issues/18088


   A clear and concise description of what the bug is.
   
   We have a combination of sales and percentage metrics in a grid report, which we use grouping functionality.  This way, users can drill down from, let's say, Division -> Region -> District, and seeing the Sales and Margin % for each one of those groupings as they drill down.  However, currently this component only allows you to specify one type of aggregation for all the metrics in the reports.  This clearly is not useful.  We need to have Sum aggregation for the sales metrics, and we might want to have the 'average' aggregation for the Margin (percentage) metrics.  Currently, we can't display the sum for the percentage metrics, because it just doesn't make sense to do so.
   
   Is this something that is in the roadmap to be fixed?  I already modified the current Table component to allow to add hierarchical drilling and aggregation per column, however, there are some other functionality that we would like to use in pivot table 2.
   
   #### How to reproduce the bug
   
   Create a dataset that you can group by with different levels, have a sales and percentage metrics in the report, and then do the aggregation.  You can select only one type of aggregation for all the metrics, instead of specifying the aggregation by column, giving us wrong results.
   
   ### Expected results
   
   I would like to specify the aggregation by column, so the totals/subtotals by grouping, show the sum for sales metrics and average for percentage metrics, for example.
   
   ### Actual results
   
   You can only select one aggregation for all metrics, which is wrong.
   
   ### Environment
   
   (please complete the following information):
   
   superset version: 1.3.2
   all browsers
   
   ### Checklist
   
   Make sure to follow these steps before submitting your issue - thank you!
   
   - [x ] I have checked the superset logs for python stacktraces and included it here as text if there are any.
   - [ x] I have reproduced the issue with at least the latest released version of superset.
   - [ x] I have checked the issue tracker for the same issue and I haven't found one similar.
   
   ### Additional context
   
   Add any other context about the problem here.
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org