Problem with filters

Question & Answer
1

Hello,

I created a filter that is used in all the visuals using the following caluclated parameter:

distinctCountOver(ifelse(status='A',{column2},NULL),[column1],PRE_FILTER)

the filter remove from the analysis all the data where the count for column1 (taking into account the column 2 value) are lower than 8.

so in this way all the data is affected by the filter on the calcualted parameterand and everything works fine.

However, I have a filter in the analysis which is based in column1 (the agg column in the calculated filed). In this filter all the different values are showed (also the one with a count lower than 8)

Is there a way to avoid that?

it can be misleading for the user of the dashboard…

thank you

2

Hi There, You may create a calculated field for column1 that would bring in only the values greater than 8 and then use that calc field to create a filter for your dashboard. That should help you achieve your requirements. Let us know.
Thanks

1 Like
3

Hello @Raji_Sivasubramaniam,

that was a smart move…I tried but actually it is not working…I created a calcualted field as you said.

If I put this calculated field in a table, I cann see only 3 of the 5 values…

If then I use the same calculated field in a filter, in the drop down menu, I can still see all the 5 values…