Re: [I] TOTALS incorrect for non-additive metric in pivot table [superset]

["goldjee (via GitHub)" <gi...@apache.org>]

goldjee commented on issue #25747:
URL: https://github.com/apache/superset/issues/25747#issuecomment-2277285422

   Bumping this because I believe that the ability to aggregate non-additive data is crucial for any BI tool. All of the major tools present on the market can handle that effortlessly.
   
   As we define SQL for measures (and they should be proper SQL aggregates) in dataset options, I think that Superset already has all the required information to calculate subtotals. So,
   
   * For each aggregation level, the pivot table could send a query to the database with properly generated GROUP BY.
   * In chart settings, the dropdown that allows to choose aggregation type can be safely removed.
   
   This approach has an obvious drawback of spamming queries if there is a lot of aggregation levels. But realistically no pivot table would have even a dozen of them, so such an overhead should be tolerable.
   
   @mistercrunch @rusackas @villebro Could we expect such a feature in one of the upcoming releases?


-- 
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