Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
When I am using '1' in set analysis its not working as expect, means filter condition mentioned in set analysis is getting impacted.
Expression
Count(distinct{<status={'a'},T_year={'$(=year(today()))'}>} ID) --> 10 (correct)
Count(distinct{1<status={'a'},T_year={'$(=year(today()))'}>} ID) --> 100 (incorrect), expected O/P -->10
I want to make this expression static from selection except the filter condition mentioned in set analysis
Even if the expression was responding to selections, it would not show a higher value
because filtering is basically reducing the amount of data to be evaluated
Can you please post a screenshot of the expression editor