lameapparition opened a new issue, #25747: URL: https://github.com/apache/superset/issues/25747
Hello, I'm new into Superset. Trying to move our analytics to this platform, but i met problem as I see no possibility of making Total row correct for non-countable (or non-additive) metric 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 UPD. Found that usual table calculates "spend rate" correctly <img width="1412" alt="image" src="https://github.com/apache/superset/assets/108183770/2449e758-e343-4c32-b066-74675961a3c8";> _Originally posted by @lameapparition in https://github.com/apache/superset/issues/14061#issuecomment-1777176807_ -- 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]
