Incubator-superset: Drill Down in Superset

[sougatabh]

Evaluating superset for our BI/analytical dashboards. Could not find drill down option. My use case would be I want to show Geo wise Sales in a Pie Chart and on click of that User should redirected to another page with Country wise Sales Chart.

Do let me know if you have anything similar to that or any workaround.
Thanks
Sougata

[mistercrunch]

Drill down assumes the framework is aware of hierarchies which Superset isn't at the moment. We encourage our users to slice and dice by entering the explore mode, applying filters and altering the "Group By" field which is pretty easy and very flexible. It's an open field instead of a guided flow.

From a dashboard, it might be unclear what the user expects when say clicking on a country. Should it filter on that country and refresh other charts in the dashboard to reflect that? Should it drill down on that one chart into one of the specified hierarchies? Should it drill down in the whole dashboard? Should it take the user to a report defined by the dashboard creator specific to that country, perhaps a "country scorecard"? Should there be a contextual menu offering these all/some of these options?

[rsxm]

We've also had customers request "drill down" functionality, but inevitably, they have different (and often incompatible) expectations on what should happen when they click on a graph. I thus agree with @mistercrunch that an "open field instead of guided flow" is more appropriate for "analytics at the speed of thought". But I've also been thinking of how to narrow the gap and allow for slightly more "guided flows" without compromising on flexibility. These are my current thoughts:

1. Extend the "table as filter" option to bar charts and pie charts for dashboards. This will cover the case where customers just want to click a slice on the piechart to filter the rest of the dashboard.

2. When clicking on "Explore this graph" in a dashboard that has filters applied, open the explore view with the same filters applied to the slice. This is perhaps the biggest point of confusion for our users at the moment: having to reapply the filters in the Explore view, especially since the filter there does not auto-complete like in the dashboard.

3. Allow slices (in one dashboard) to act as a portal to another dashboard. Currently we just add a link in the slice description to related dashboards, but it would be really cool if you could select a "related dashboard" from a dropdown in the "edit slice" view from the dashboard, and then (for example) when clicking on a a country in the World map slice the "Sales" dashboard open up with the country applied as filter.

I've not looked into the technical feasibility of these yet (or even if it's already addressed in versions since Superset v0.17.0!), but do you think it's worth exploring these ideas?

[sougatabh]

Thanks @mistercrunch @jr-minnaar for your answer.
My use case : Assume I have a page showing multiple KPI chart geo wise, assume page has 5 charts a pie, a Bar a table blah, blah, blah.. Now on click of any bar I want to redirect to another page, where I am showing same KPI by country, Page 2 I designed separately as it require different sort of chart. Is this doable? To be precise I want to know can I make chart/tables clickable and forward to another page?

Thanks Again
Sougata

[sipra24]

can we go to another slice if we click on a bar from the bar chart ?

[mistercrunch]

@sipra24 not currently possible. The question is how we would let the user (or dashboard creator) define what that action should do.

[pajachiet]

I confirm @jr-minnaar second point is the biggest point of confusion for our users. Should we open a specific github issue to follow this idea ?

[xrmx]

@pajachiet better open a PR that fixes it than duplicate an issue i think :)

[pajachiet]

Indeed :) We should fix the csv export from dashboard view (issue and PR) at the same time, as it does not apply filters.

csv export on dashboard page with filters applied would be a great feature to export the result of interactive analyses

[mistercrunch]

CSV and Explore link on dashboards does carry filters through now (on the master branch)

[mistercrunch]

Notice: this issue has been closed because it has been inactive for 220 days. Feel free to comment and request for this issue to be reopened.

[Neuliaus]

Hi , We would love this to be follow through, and more we are willing to put some resources to help out and get it done.

The things have currently been working with different levels of success :
1- CrossFilter,js (D3 cross filter) defining the different charts form same data source ingested to Druid after pre-transformation using sparks, POC but not ready to produce
2- We've added new Charts from D3 and currently on MVP, once proven successful we will share with the community
3- Drill Down, we have a suite of an interactive report in another platform which gives us a clear roadmap of hierarchies, groups and Drills down , but it's safe to say that they are mostly time series related, where we receive data in a range of resolutions but the smallest one is every 5 sec, then the user can drill down from year to qtr, month, day, to sec, this, however, we've just started exploring and it really is dependent on cross drilling and rules around it .

Our staging setup is Kubernetes, Dockers, Superset image, Druid, Helm. On AWS currently on Batch Ingesting as our first report are received daily batches with 5min resolution, I'll be super happy to share as our data and report are for a completely different industry

[arvindpl]

Which another project are you referring to for drill down?

[srimalj]

Hi All

First of all I have found Superset to be a very useful opensource BI tool.

But I have to agree with the original poster that, that this type of cross-filter support (or drill down as mentioned above) is a badly needed feature.

I think some of the older Superset (or was it caravel at the time) had limited support for crossfiltering with pivot tables but it seems this feature was dropped in subsequent releases.

Just to add to the last comment:

Which another project are you referring to for drill down?

Most commercial BI tools such as Tableau and PowerBI support crossfiltering out of the box.
And the open source javascript library dc.js has this functionality out of the box.

Doesn't Superset use dc.js too?

I'm not fully aware of the Superset architecture to comment, but its a pity if this feature is dc.js has this ability and Superset doesn't.

Superset would be a great alternative to commercial tools if we could have crossfiltering support.

Cross filtering in Superset could initially be a limited to a subset of widgets to start with, perhaps with an option to turn it on and off for each dashboard. This is in case users do not want to have it on for certain dashboards.

Cheers

[pavitranrambo]

Hi! I created a new issue but was unaware of this thread.

I have attempted a prototype for multi chart and single chart drilldowns using HighCharts (for now).

I agree drilldown is a needed feature as it is more intuitive for the end user to filter charts and if anyone is willing to follow up on this idea please do reply to this post :)

[Neuliaus]

Hi! I created a new issue but was unaware of this thread.

I have attempted a prototype for multi chart and single chart drilldowns using HighCharts (for now).

I agree drilldown is a needed feature as it is more intuitive for the end user to filter charts and if anyone is willing to follow up on this idea please do reply to this post :)

I'm in how far did you got, wanna do some collaboration?

[pinky884]

Is drill down possible in superset today? If yes, can anyone please provide the steps/layout to choose to create the same as I am not seeing any option to create a drill down graph.

[pavitranrambo]

Hi! I created a new issue but was unaware of this thread.
I have attempted a prototype for multi chart and single chart drilldowns using HighCharts (for now).
I agree drilldown is a needed feature as it is more intuitive for the end user to filter charts and if anyone is willing to follow up on this idea please do reply to this post :)

I'm in how far did you got, wanna do some collaboration?

Sure! I have created a guided flow drilldown thus far.

However, as of right now, it only supports normal groupby filtering (does not support time-based filtering). So would you like to help me on that?

[pinky884]

Yeah sure.. I can help you... let me know what needs to be done and I will work through it.

[ku2madman]

@mistercrunch I think metabase "drill-through" function may give you some ideas, see https://www.metabase.com/docs/latest/enterprise-guide/customizing-drill-through.html

[yonatanpc]

Hi! I created a new issue but was unaware of this thread.
I have attempted a prototype for multi chart and single chart drilldowns using HighCharts (for now).
I agree drilldown is a needed feature as it is more intuitive for the end user to filter charts and if anyone is willing to follow up on this idea please do reply to this post :)

I'm in how far did you got, wanna do some collaboration?

Sure! I have created a guided flow drilldown thus far.

However, as of right now, it only supports normal groupby filtering (does not support time-based filtering). So would you like to help me on that?

Hi @pavitranrambo, I would like to help as well if this still relevant, please share a PR or some GitHub code and let us know what is needed.

[glarkou]

Hi! I created a new issue but was unaware of this thread.
I have attempted a prototype for multi chart and single chart drilldowns using HighCharts (for now).
I agree drilldown is a needed feature as it is more intuitive for the end user to filter charts and if anyone is willing to follow up on this idea please do reply to this post :)

I'm in how far did you got, wanna do some collaboration?

Sure! I have created a guided flow drilldown thus far.
However, as of right now, it only supports normal groupby filtering (does not support time-based filtering). So would you like to help me on that?

Hi @pavitranrambo, I would like to help as well if this still relevant, please share a PR or some GitHub code and let us know what is needed.

We would like to contribute as well if you already started working on it!

[mohan770]

Hi @mistercrunch Im unable to create line chart in superset even I imported date correctly it is not showing it would be helpful if u give some info about this.