jacobcroope opened a new issue #18836: URL: https://github.com/apache/superset/issues/18836
We are interested in calculating a fair share metric which requires dividing two percentages within a table. The percentage metrics correctly calculate a % of what is displayed in a table dynamically with filters which is critical to our application. Here is a screenshot of the type of visualization I am trying to make. I would expect the value to be an index around 1. For Wii Sports with 20.38% of North American Market and 22.39% of Global Market the value should be 91%  The SQL statement is dividing them before calculating percentages.  In PowerBi, Tableu, and Excel there is a way to accomplish this. Is there a way to do this in Superset I am unaware of or is this something that needs to be added to the visualization? Other operations don't provide the expected results either.  ### Environment Superset - Current as of today. ### 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. -- 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]
