Dynamic column and metric selection in pivot table #27240
Replies: 9 comments 5 replies
-
It's great! Can you please describe how install this? |
Beta Was this translation helpful? Give feedback.
-
Hi, @BharatNischal, i'm also having problems with pivots on my organisations, and your solution suits perfectly. How can access and install this? |
Beta Was this translation helpful? Give feedback.
-
Hi there, and thanks for starting this conversation. I have a handful of questions:
Also, this has a little bit of overlap with the Drill By functionality that's currently on the roadmap. @lauderbaugh and @kasiazjc may be interested in taking a look. |
Beta Was this translation helpful? Give feedback.
-
@BharatNischal Hello there! Thank you so much for making this, it's exactly what I need! Would you mind sharing how you achieved this, or does anyone know if there is now a way to do this natively in Superset? Any help or guidance would be greatly appreciated! |
Beta Was this translation helpful? Give feedback.
-
Converting to a GitHub discussion. |
Beta Was this translation helpful? Give feedback.
-
Hi, @BharatNischal, i'm also having problems with pivots on my organisations, and your solution suits perfectly. How can access and install this? |
Beta Was this translation helpful? Give feedback.
-
@BharatNischal How can I use in Apache Superset, I am working on some dashboards and I need this chart in utmost top priority.. Please share :) |
Beta Was this translation helpful? Give feedback.
-
Which superset version has the solution in the video? I want to use the functions to dynamically select columns and metrics . @dosu |
Beta Was this translation helpful? Give feedback.
-
Lots of enthusiasm on this thread, I love to see it! @BharatNischal did you ever get this plugin in a shippable state? If it's hosted somewhere on NPM, I'd love to add it to the Third Party Plugins list and give it some love! |
Beta Was this translation helpful? Give feedback.
-
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.
Screen.Recording.2022-03-27.at.11.45.09.AM.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
Beta Was this translation helpful? Give feedback.
All reactions