[GitHub] circld edited a comment on issue #4054: Feature Request : currently we can't summarize pivot table/ table as % value of row total/ column total/ grand total

[GitBox <gi...@apache.org>]

circld edited a comment on issue #4054: Feature Request : currently we can't summarize pivot table/ table as % value of row total/ column total/ grand total
URL: https://github.com/apache/incubator-superset/issues/4054#issuecomment-406697119
 
 
   This would be a useful feature to greatly extend the expressiveness of the pivot table chart, i.e., to represent "wide" vs "long" data.
   
   To illustrate, suppose have data for school students with a letter grade for each subject. Further suppose that we would like to calculate the count by subject and grade. In this case, we can use either visualization type:
   
   ### Table View
   |subject|grade|count|
   |-|-|-|
   |English|A|50|
   |English|B|85|
   |English|C|39|
   |English|D|12|
   |English|F|0|
   |Math|A|44|
   |...|...|...|
   
   ### Pivot Table
   |subject|A|B|C|D|F|all|
   |-|-|-|-|-|-|-|
   |English|50|85|39|12|0|186|
   |Math|44|...|...|...|...|...|
   |...|...|...|...|...|...|...|...|
   
   If we now would like to see the percentage of students by letter grade within each subject, we are out of luck. `Table View` exposes "Percentage Metrics", but the percentages use the number of students across all subjects and letter grades as the denominator.
   
   If, on the other hand, "Percentage Metrics" were implemented for `Pivot Table` and this added a percentage for each column calculated over the row total, we would be able to express the ask.
   
   In any case, this would be a useful feature (although I'm sure there are design/implementation details to nail down), and hopefully the example above illustrates how such a feature would extend Superset's expressiveness in tabular "visualizations" even further.

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org