[Feature request] Intra Dashboard Interaction (Publish Subscriber Design Pattern)

[jitendra-kumawat]

Most of BI Tools have features of Data Drill Down and Dashboard Linking but superset doesn't have this in design so this is Design Proposal to add these features in superset and we can serve below use cases

Use cases
Intra Dashboard Interactivity means whenever user do selection over any visualization/chart in Dashboard then selection of that chart can apply to rest/set of charts in following manner depends on UX/Usecases-

Apply as filters/global filters in sql query as where clause with required query operators referred as applyFilter
Change model or schema of chart referred as changeConfig
Show information in popup referred as showPopup
Redirect to new URL or any other dashboard url referred as redirectToUrl
Mix of any action listed above referred as applyFilter and configChange
Selection sync or highlight same selections in different charts referred as highlightSelections

Design

To solve above use cases here is a design proposal to implement above feature in superset and calling it as Publish Subscriber Design Pattern , in this any charts which is used for selection (via click or user-interaction) called as Publisher and rest /set of charts listening these selections and update itself based on action defined called as subscribers.
refer to following terminology

• Publisher - any chart publish selection on click
• Publish Columns - list of columns and respective data published in form of selection
• Subscriber- any chart subscribe selections published by publisher
• Action - action need to execute on subscription, actions can be any above use case listed in introduction (1-6)
• Operator- SQL query operators used while creating where clause like =,!=,IN etc
• Subscribe Columns- subscriber can choose columns from publish columns before execute action
• Extra- store extra metadata required like publish value can map with chart ids to dynamic chart changes
• Interactor - acts mediator between charts and dashboard to identify publisher, subscriber and execute action with correct information
• PubSubMetaData - metadata info related to publisher and subscriber

Design Flow screenshot

1. Over all design flow diagram

** 2. UI for get info of publishers and subscribers from user**

Steps

1.There is a option on Dashboard to configure above parameters
2. A separate UI at dashboard level open to set PubSub info from USER and store it as PubSubMetaData .
3. once user will choose this option and it will store in Dashboard state and MetaData.

Describe alternatives you've considered
We can implement above design in two stages

Phase -I

• All Pub sub info will be store at Chart level in form data and new options will be defined and added in PubSub section of Chart
• PubSubMetaData will be created from slices and store at dashboard level and Options of Reconcile will be provided at dashboard level
• once user will choose this option PubSubMetaData will create and store
• interactor will be implemented as per design.

Phase -2

• Designed UI will be implemented as per design and read all pubsub info from UI instead slices formdata
• Reconcile option change to Configure Filters and update functionality

Additional context
NA

If anyone have any thoughts related to this type of feature then we can have a discussion further .

[issue-label-bot]

Issue-Label Bot is automatically applying the label #enhancement to this issue, with a confidence of 0.95. Please mark this comment with 👍 or 👎 to give our bot feedback!

Links: app homepage, dashboard and code for this bot.

[graceguo-supercat]

@xtinec take a look!

[jitendra-kumawat]

@xtinec , if you have any thoughts over this design we can discuss .

[jitendra-kumawat]

@mistercrunch @graceguo-supercat ..any thoughts or input over this feature

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. For admin, please label this issue .pinned to prevent stale bot from closing the issue.

[satishabburi]

Any input on when this feature scheduled for development?

[kalimuthu123]

any update about this feature

[Mabloq]

Need this feature for the execs that dont know how to investigate data on their own. They just want the intuitive "click to go deeper" approach. This sounds like a really cool design and I hope it gets picked up!

[tomrod]

Agreed with these comments. Lack of this feature will probably prevent adoption by my org.

[ITNoesis]

This is highly desirable..

[junlincc]

We are aware of the high demand of this feature, and have been working on setting up the architecture to enable cross filtering, drill down etc. that PowerBI and other BI tools offer.
we don't have committed timeline yet, but it's definitely happening!

[villebro]

FYI as part of the dashboard native filter project we've recently introduced a new hook to viz plugins that can be used to push data from a viz to the dashboard. For now it's mostly limited to adding filters and overriding temporal parameters (time range, time grain etc), but we're also looking into supporting other types of interaction, like changing groupbys etc. This can be used to drive cross filtering between charts and also drill downs down the road. See the setExtraFormData hook in apache-superset/superset-ui#840

[eddymoussallem]

We are aware of the high demand of this feature, and have been working on setting up the architecture to enable cross filtering, drill down etc. that PowerBI and other BI tools offer.
we don't have committed timeline yet, but it's definitely happening!

Glad to hear!!!!

[inviscid]

Based on @villebro comment above, is there a timeline for when we might be able to perform drill through natively?

[pundirg]

is there any updates or timeline ? this feature will provide wider adoption

[jhult]

Looks like there is some good progress in this PR: #14688