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?
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.
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?
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:
Hi Quentin, could you expand on your answer?