cancel
Showing results for 
Search instead for 
Did you mean: 

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

MuznahM
8 - Cloud Apps
8 - Cloud Apps

MuznahM_1-1723448454220.png

 

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

9 REPLIES 9

AssafHanina
Sisense Team Member
Sisense Team Member

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

AssafHanina_0-1723541599123.png

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

 

Assaf

Thank you @AssafHanina 

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

Regards
Muznah

AssafHanina
Sisense Team Member
Sisense Team Member

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

Assaf

irismaessen
11 - Data Pipeline
11 - Data Pipeline

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.

Aneetta
7 - Data Storage
7 - Data Storage

Hi @irismaessen ,

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

irismaessen
11 - Data Pipeline
11 - Data Pipeline

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

DRay
Community Team Member
Community Team Member

Hello @MuznahM.

Were you able to get this resolved?

David Raynor (DRay)

MuznahM
8 - Cloud Apps
8 - Cloud Apps

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

AssafHanina
Sisense Team Member
Sisense Team Member

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:

  1. 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. 
  2. In the Default tab Configuration:
    - displayWidgetIds : [""] - remain empty
    - hideWidgetIds : [""] - contain the drill widget list
  3. 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:

AssafHanina_0-1724427168138.png

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

AssafHanina_1-1724427205981.png

General Notes:

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

@MuznahM please update if this solve the issue. 

Best Regards

Assaf