topic Re: Set analysis in App Development

Set analysis

Sagar082 — Mon, 27 Sep 2021 10:09:06 GMT

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.

Re: Set analysis

tresB — Mon, 27 Sep 2021 10:44:58 GMT

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)

Re: Set analysis

Sagar082 — Mon, 27 Sep 2021 11:06:22 GMT

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.

Re: Set analysis

tresB — Mon, 27 Sep 2021 11:20:59 GMT

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.

Re: Set analysis

akshatagrawal — Tue, 28 Sep 2021 05:42:14 GMT

Please use below expression,

Count({$<Date=, var1 = {criteria 1}, var2 = {criteria 2}>} measure variable)

Thanks & Regards

Akshat Agrawal

Re: Set analysis

Sagar082 — Tue, 28 Sep 2021 08:22:27 GMT

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

Re: Set analysis

Sagar082 — Tue, 28 Sep 2021 08:23:10 GMT

Hi,

Thank you for reply, but it is not working.

Re: Set analysis

Sagar082 — Tue, 28 Sep 2021 08:28:34 GMT

Hi Akshata,

Thank you. It is working, please ignore my previous reply.

Re: Set analysis

akshatagrawal — Tue, 28 Sep 2021 09:01:05 GMT

Good to know!!

Thanks & Regards

Akshat Agrawal