Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Is there way to set certain filter in script, rather than ammending each formula in the app with set analysis?
I have loaded data for 2 organizations into the app.
Company:
Beta
Gamma
I want to SUM (< {Company={'Beta'} }> Sales), but i want to write something in the scipt which will effect the whole application and make possible using SUM (Sales) to return sales for Beta company (w/o set analysis).
I don't want to check all pages of my monster script for the places where I could have used Company field.
Is it possible with one line in the end of the script?
Cheers!
Hi
try with
where match(company)='Beta';
Hi
Small syntax change
method1:
where company='Beta';
mehod2:
where match(company,'Beta');
Keep in mind that your dashboard will now only contain the records where Company = 'Beta'
If you want to see any other companies they will not be in your load. That is why we use Set Analysis so that we can load more data but only see what we want to see in a visualization.