Skip to main content
Nintex Community Menu Bar
Question

Multi-select Option filter on a table - display in chart title when activated

  • Jul 11, 2024 1:10 PM UTC
  • 4 replies
  • 55 views
  • Translate All

Forum|alt.badge.img+3

Hi,

I have a table with a multi-select option filter, there is a chart linked to the table which dynamically updates when the filter is activated.

I have been asked if we can display the values selected in the multi-select option filter in a chart title. Has anyone tried doing this?

Thanks

Damien

This topic has been closed for replies.

4 replies

Forum|alt.badge.img+10

Damien,

Here is a snippet that demonstrates how to add to the chart title.  Create the snippet and set it to run before rendering the chart (click on the chart, find the Advanced tab in the properties area, and select the snippet in the Before Render Snippet option).  You will need to adjust the model and the name of the condition.

Thanks,

Bill

var params = arguments[0],<br>$ = skuid.$;<br>var model=skuid.model.map().Opportunity;<br>console.log('model');<br>console.log(model);<br>var con=model.getConditionByName('__autofilter__StageName');<br>console.log(con);<br>var val = con.values;<br>console.log(val);<br>if (val !==undefined) {<br>&nbsp; &nbsp; var display ='';<br>&nbsp; &nbsp; for (var i=0; i &lt; val.length; i++) {<br>&nbsp; &nbsp; &nbsp; &nbsp; display += val[i];<br>&nbsp; &nbsp; &nbsp; &nbsp; if(i!==(val.length -1)) {<br>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; display += ', ';<br>&nbsp; &nbsp; &nbsp; &nbsp; }<br>}<br>console.log('display');<br>console.log(display);<br>params.title.text = params.title.text + ': ' + display;<br>&nbsp; &nbsp;&nbsp;<br>}

Translate

Forum|alt.badge.img+3

Thanks Bill, that works perfectly!

Have you tried this with multiple picklists? 

Thanks 

Damien

Translate

Forum|alt.badge.img+10

Damien,

It does work with multi-select filters.  I am not sure about multi-select pick list fields.

Thanks,

Bill

Translate

Forum|alt.badge.img+3

Thanks Bill, really appreciate your help.

Thanks 

Damien

Translate