Selected value in accordion widget is not getting change the parent dashboard filter in Sisense Why?

I want to display the filtered values in the parent dashboard filter based on the selection made inside an accordion widget. Is that possible?

MuznahM

Posted 2 years ago·Last reply 2 years ago

9 comments

DRay

·2 years ago

Hello MuznahM.

Were you able to get this resolved?

MuznahM

OP2 years ago

Hi DRay

I haven't been able to resolve this issue yet. Since we need to display all the widgets on the same dashboard, I don't think Tabber is the right solution for us.

Thanks for understanding,
Muznah

Assaf Hanina

·2 years ago

hey MuznahM ,

the Tabber is not linked directly to the indicator but can replace the Accordion and interact with the Filters.

Please find an example:

Created Tabber widget with 2 tabs:
- Default tab - when users open the dashboard, the drill is not opened
- Drill tab - when users explore more information about the indicator and interact with the dashboard filters.
In the Default tab Configuration:
- displayWidgetIds : [""] - remain empty
- hideWidgetIds : [""] - contain the drill widget list
In the Drill tab Configuration:
- displayWidgetIds : [""] - contain the drill widget list
- hideWidgetIds : [""] - remain empty

Tabber Configuration

// tab configuration

widget.tabs = [{title: "Default - Tabber Closed", 
			displayWidgetIds : [""],
			hideWidgetIds : ["66c8a7474b2ebd004276cf54","66c8a70a4b2ebd004276cf50"]},
			   {title: "Drill Open - Replace Accordion", 
			displayWidgetIds : ["66c8a7474b2ebd004276cf54","66c8a70a4b2ebd004276cf50"],
			hideWidgetIds : [""]}
		];

// style configuration

widget.on('render',function(w, e){e.prefixText = '';
			e.suffixText = '';
			e.selectedColor = '#86b817'; /*The color of the chosen title*/
			e.fontColor = '#cccccc'; /*The color of the unchosen titles*/
			e.elementWidth = '103%';
			e.descColor = '#a5a5a5';
			e.parentMarginLeft = '-15px';
			e.height = 32; /* affects the tabber widget default high*/
			});

Example when the Tabber is on Default:

When the Tabber is Open - both widgets include and interact with the filters

General Notes:

the tabber can be placed as any other widgets.
the tabber load all the widgets, display and hidden which might increase the dashboard load time
the Accordion is loading the dashboard only while click

MuznahM please update if this solve the issue.

Best Regards

Aneetta

·2 years ago

Hi irismaessen ,

Can you explain how to replace the accordion with tabber in a KPI widget?

irismaessen

·2 years ago

Hmm.. Linking it directly to a KPI widget is not possible as far as I know but you should be able to arrange the buttons of the tabber widget in such a way that there's a tabber button directly underneath the KPI widget, perhaps?

Iris

irismaessen

·2 years ago

Instead of the fold-out of another dashboard that is the Accordion, you might consider using a Tabber instead. Tabber shows/hides widgets on the dashboard itself depending on the selected tab from the widget.

Because the widgets are still on the dashboard itself, you can have the filters from widgets inside the tabber affect the main dashboard even if they get hidden afterward.

Assaf Hanina

·2 years ago · Edited

hey MuznahM ,

The accordion Plugin design to Inherit filters from the Main Dashboard and not the Other way around.
Below are the Objects which can be defined for the Accordion Plugin, according to the Technical Details in the Plugin page

Suggest to review several Alternative options such as:

Use the filter from the Main dashboard and Inherit it for the Drill dashboard
Using Widget filter in the main dashboard
Include the widget in the main dashboard

Best Regards

Assaf

MuznahM

OP2 years ago

Thank you AssafHanina

Is there another solution for this, such as using a script?

Regards
Muznah

Assaf Hanina

·2 years ago

hey MuznahM ,

it might be possible using a Script but I'm not familiar Script related.

In case the Drill dashboard is heavily used, i do think that Including the Drill Widgets which require to be filtered on, in the main dashboard will provide the needed solution without the need of additional customization and Load time (of the Accordion)

Best Regards