Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Drill Down in Superset #2890

Closed
sougatabh opened this issue Jun 2, 2017 · 22 comments

Comments

@sougatabh
Copy link

@sougatabh sougatabh commented Jun 2, 2017

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

This comment has been minimized.

Copy link
Member

@mistercrunch mistercrunch commented Jun 2, 2017

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?

@jr-minnaar

This comment has been minimized.

Copy link
Contributor

@jr-minnaar jr-minnaar commented Jun 3, 2017

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

This comment has been minimized.

Copy link
Author

@sougatabh sougatabh commented Jun 4, 2017

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

@mistercrunch

This comment has been minimized.

Copy link
Member

@mistercrunch mistercrunch commented Jun 5, 2017

@jr-minnaar I agree with your 3 points. #2 could be considered a bug. About #3 it's possible [but tricky] to do this today by creating a tag as a calculated column.

@sipra24

This comment has been minimized.

Copy link

@sipra24 sipra24 commented Jun 21, 2017

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

@mistercrunch

This comment has been minimized.

Copy link
Member

@mistercrunch mistercrunch commented Jun 23, 2017

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

@pajachiet

This comment has been minimized.

Copy link

@pajachiet pajachiet commented Sep 4, 2017

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

This comment has been minimized.

Copy link
Contributor

@xrmx xrmx commented Sep 4, 2017

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

@pajachiet

This comment has been minimized.

Copy link

@pajachiet pajachiet commented Sep 8, 2017

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

This comment has been minimized.

Copy link
Member

@mistercrunch mistercrunch commented Sep 15, 2017

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

@mistercrunch

This comment has been minimized.

Copy link
Member

@mistercrunch mistercrunch commented Apr 23, 2018

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

This comment has been minimized.

Copy link

@Neuliaus Neuliaus commented Sep 11, 2018

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

This comment has been minimized.

Copy link

@arvindpl arvindpl commented Sep 14, 2018

Which another project are you referring to for drill down?

@srimalj

This comment has been minimized.

Copy link

@srimalj srimalj commented Jan 10, 2019

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

This comment has been minimized.

Copy link
Contributor

@pavitranrambo pavitranrambo commented Jan 29, 2019

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

This comment has been minimized.

Copy link

@Neuliaus Neuliaus commented Feb 20, 2019

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

This comment has been minimized.

Copy link

@pinky884 pinky884 commented Feb 25, 2019

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

This comment has been minimized.

Copy link
Contributor

@pavitranrambo pavitranrambo commented Feb 26, 2019

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

This comment has been minimized.

Copy link

@pinky884 pinky884 commented Feb 26, 2019

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

@ku2madman

This comment has been minimized.

Copy link

@ku2madman ku2madman commented Jul 20, 2019

@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

This comment has been minimized.

Copy link

@yonatanpc yonatanpc commented Jul 25, 2019

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

This comment has been minimized.

Copy link

@glarkou glarkou commented Aug 19, 2019

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!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
You can’t perform that action at this time.