Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I want to do a measure for sum a value but I want to ignore user selection on a filter and set this filter to an specific value.
I show you what I want to:
sum({< field_a= {"7"}
, field_b -- ignore user selection
, field_b = {"ABCD"} -- set to a specific value
>} measure_a)
In this case, I want to ignore the user selection on "field_b" and set it with a specific value, "ABCD" .
I don't how to do it ...
Can you please help me with that?
Thanks!
Hi, Javi,
When you specify a filter for a field in set analysis, you are already disregarding user's selection for that field. So you only need to do this:
sum({< field_a= {"7"}
, field_b = {"ABCD"}
>} measure_a)
Hmm it doesn't work, but I don't know why...
I mean, for example if I filter FIELD_B to "1234" and I use that set analysis the measure shows empty.
Can you send a screenshot of your data model?