Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys, I need your help.
I have a bar chart with multiple measures calculated like this:
sum (
if(transaction_date-original_transaction_date<=5 and fl_return=1,1,
0
))
The point is: I would like to be able to filter the entire dashboard on these measures
create a new field during data load and then apply a 9filter on this new field
SomeTable:
load *
,if(transaction_date-original_transaction_date<=5 and fl_return=1,1) as flag_field
From someSource;
Then use this field to either apply a filter
or
Use in set analysis in your measures
sum({<flag_field={1}>} someMeasure)