Applying one filter to multiple charts

Ask us anything
1

Hi everyone,

I have 10 input elements set up as filters. I want to apply the user’s choices to multiple charts. Is there a way to do this without having to recreate a filter with 10 parameters for each chart?

2

I’ve realized I could do this with array formulas - specifically lookupArray - if I had discrete values, but I need to do >X AND <Y.

3

Did you try with a global workflow that will store the end filter to a variable? And then binding all the charts to the same variable?

4

Am I right in thinking this would be an array of filter criteria, which is updated each time a filter input element is changed?

In case it helps, here are my filters, which have to be applied to multiple charts, a map, and a datagrid:

image
image1524×1584 118 KB

5

Hi Quentin, could you expand on your answer?