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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
