Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, folks
I have created set expression for a chart like,
Count({$<var1 = {criteria 1}, var2 = {criteria 2}>} measure variable)
Now I added date pan for another chart, as soon as I select the date it impact other charts.
I need to exclude the date selection impact from previously defined set expression. So, eventhough date is selected the result should return only for above set expression.
Can someone guide on it.
Please use below expression,
Count({$<Date=, var1 = {criteria 1}, var2 = {criteria 2}>} measure variable)
Thanks & Regards
Akshat Agrawal
Disregarding a dimension selection in set analysis is easy, just mention it and leave it with a comma, like:
Count({$<yourDate, var1 = {criteria 1}, var2 = {criteria 2}>} measure variable)
Tresesco,
Thank you for reply. But you misunderstood my requirement. I don't want to take impact of date column, I need to excluded it.
At present if I select the specific date from filter pan then it modifies the respective chart as well as the chart which has set expression too.
The former one is good, but later one is not.
To exclude date selection, you have to include the date field in set analysis as I showed. If it's not working, that could be because you are using a bit more complex expression than you are showing here that is probably having some calculation as well with some aggregation function.
If you can share your actual expression (if variable is there, please share it's definition as well), I could take a look and help.
Please use below expression,
Count({$<Date=, var1 = {criteria 1}, var2 = {criteria 2}>} measure variable)
Thanks & Regards
Akshat Agrawal
Hi,
Please note the expression as below,
Count({$<life_cycle = {'registered'}, incidence_type = {'isolation'}>},id)
Where life cycle is state of incidence and incidence type is type of incidence.
If I select date then stats only visible for that date, that I need to get rid off
Hi,
Thank you for reply, but it is not working.
Hi Akshata,
Thank you. It is working, please ignore my previous reply.
Good to know!!
Thanks & Regards
Akshat Agrawal