[GitHub] [superset] BharatNischal opened a new issue #19384: Dynamic column and metric selection in pivot table

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

BharatNischal opened a new issue #19384:
URL: https://github.com/apache/superset/issues/19384


   **Is your feature request related to a problem? Please describe.**
   We recently switched to superset for the visualisation needs at my organisation. We need to create a pivot table for visualising a number of metrics for example city vs (completed orders, delivered orders, pending orders etc) just to name a few. So for this we used superset's Pivot Table 2.  We are operating in multiple businesses and after plotting all the required metrics of each business we end up in 100+ pivot table charts.
   
   Now when I added all these charts in a dashboard it become very difficult to search for a specific chart. Also now if I need to share this dashboard with a person who is only concerned about 3-4 charts the dashboard will still make an api call to all 100+ charts resulting in slow loading.
   
   It is also worth mentioning that most of the charts were having same row and metrics but different. columns.
   
   **Describe the solution you'd like**
   A good solution will be to provide a dynamic selection of columns and metrics to reduce this number of charts and thus reducing loading time on dashboard resulting in better user experience.
   
   For my use case I had developed a similar chart on top of the Pivot Table v2 which is capable of this dynamic selection. Now I want this to be available to the superset Pivot Table v2 so that others can make use of this as well. Here is a demo of the proposed chart.
   
   https://user-images.githubusercontent.com/33544814/160270117-cc4c5f30-4768-4a38-af7c-124d5af4f868.mp4
   
   Note that in the demo video I haven't made metric dropdown multiselect but for generic case we should make it multiple select and the control option labels should also be renamed to more logical labels
   


-- 
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: notifications-unsubscribe@superset.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



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