lameapparition commented on issue #14061: URL: https://github.com/apache/superset/issues/14061#issuecomment-1777176807
Hello, I'm new into Superset. Trying to move our analytics to this platform, but i met a fundamental problem as I see no possibility of making Total row correct for non-countable (or non-additive) metric, guess it's related to this topic Example: I have three metrics grouped by month: 1. "spend plan" – amount of money company was planning to spend 2. "spend fact" – amount of money company actually spended 3. "spend rate" – ratio of spend fact and spend plan So, I created pivot table and added totals. "spend plan" and "spend fact" are ok – its totals are sums of all values but for "spend rate" I also see sums of all values instead of ratio of "spend fact" and "spend plan" totals <img width="1415" alt="image" src="https://github.com/apache/superset/assets/108183770/d47cbf45-407d-4555-84df-4038d97f2b12";> <img width="366" alt="image" src="https://github.com/apache/superset/assets/108183770/b20c64e4-526e-43f3-8b6c-b3f93e4f92b7";> Expected result (using Google Spreadsheets): <img width="1176" alt="image" src="https://github.com/apache/superset/assets/108183770/fa0b9f10-79b9-42dc-b582-58935b16432c";> Maybe I'm missing something, hope to get help -- 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]
