Incubator-superset: Feature: Drill down

Created on 14 Apr 2016  路  32Comments  路  Source: apache/incubator-superset

Hi,

Is there any entry on the roadmap to add drill down functionality to existing vizs (maybe table, map, ..) ?
Like:
image

Thanks

request inactive

Most helpful comment

@rpwils my thinking is I have a bar chart that shows numbers grouped by some dimension, e.g. state (USA), and if I click on a bar for Georgia, I then see a bar chart where each bar is a city in Georgia. So you're basically applying a filter and then a lower-level group by

If we're talking about doing it at the slice-level, think Bar Charts make the most sense here. Also the Country Map where I can drill from one admin level to a lower-level one, so you're essentially swapping shapefiles

I've had clients want the entire dashboard to have this drill-in capability, so I have a series fo charts grouped by state, and then if I drill into a particular state, the entire dashboard is updated, so it's essentially a hyperlink from a dashboard summarized at the state level to a dashboard summarized at the city level with a filter applied for the state I select

All 32 comments

The framework could provide hooks for contextual menus on metrics and dimensions, individual visualizations would have to implement them individually.

There's definitely a lot rich interactive features that move the needle towards a more complex contract between the framework and individual visualizations. While this is nice, it makes it harder to add new visualization to the framework.

Maybe individual visualization can have different level of support for the framework's more advanced features (like contextual menus), and grow that over time. The downside of that is an uneven user experience across visualizations, where you might expect to be able to right click on the treemap, but the contextual menu hasn't been implemented for that specific visualization yet...

It's important for me to keep the contract simple so that we can grow a wide array of visualizations.

@williaster

Yep, it's a big challenge, I think clear JS API (https://github.com/airbnb/caravel/issues/216#issuecomment-204276738) will help. Any advance on this ?
Here's how Microstrategy's HTML5 viz API works it is a good example IMO: https://lw.microstrategy.com/msdz/MSDL/10/docs/DevLib/sdk_viz_HTML5/index.html

+1

Wouldn't the Pivot table be a good starting point?

e.g. Use some pre-defined columns - click an expand button to go slice by the next level.

+1 for this :D even if only for a subset of viz types.

+1 Really interesting feature

+1 we really need it

+1 we really need it.
Any visibility on its implementation?

If you people really need it nobody is stopping you to do the work, thanks!

This is complex enough that it would require starting with a design proposal.

+1 we need it

+1 we really need it

+1 And we need it too

to @mistercrunch comment, does anyone have a design? We would be happy to help on parts of this feature if we could get input on the design

+1 we need it too

+1

+10!

Can someone explain how they would want this feature to work? We have thought about adding the ability to select a attribute on one slice and then right click and select drill and have it open up a different slice filtered on the value selected in the original slice. This would require someone to pre-build both slices and how they connect.

@rpwils my thinking is I have a bar chart that shows numbers grouped by some dimension, e.g. state (USA), and if I click on a bar for Georgia, I then see a bar chart where each bar is a city in Georgia. So you're basically applying a filter and then a lower-level group by

If we're talking about doing it at the slice-level, think Bar Charts make the most sense here. Also the Country Map where I can drill from one admin level to a lower-level one, so you're essentially swapping shapefiles

I've had clients want the entire dashboard to have this drill-in capability, so I have a series fo charts grouped by state, and then if I drill into a particular state, the entire dashboard is updated, so it's essentially a hyperlink from a dashboard summarized at the state level to a dashboard summarized at the city level with a filter applied for the state I select

To support this and "cascading filters", Superset needs to know about dimension hierarchies. I suspect hierarchies for cascading filter will become a reality before the in-chart right-click context menu with a drill down option.

Is anyone actively working on cascading filters

@csc5k this is exaaactly what is needed.

+1

+1

+1

+1

+1

+1

+1

+1

Any inputs on Drilldown option? Appreciate if any references as well..

12148

dashboard native filter and cascading filter are available for testing!! thanks in advance for feedback, comments, critics, love and support!!

drilldown is coming soon too

Was this page helpful?
0 / 5 - 0 ratings