Multiple Alternate states - set analysis for default state chart

MPkg — Wed, 03 Aug 2022 07:10:15 GMT

Hello,

I have a problem using alternate state in comparison of elements of fields.

I have table:

Groups

Main1

Main2

and following tables:

the formula for calculation is:

let vFormula='if(GetSelectedCount(Main1)=1,A_1*2+B_1*3+C_1*4,0)+if(GetSelectedCount(Main2)=1,A_2*2+B_2*3+C_2*4,0)';

I created two Alternate states: As1 and As2 and applied them to two Filter panes:

First filter pane: Groups;

Second filter pane: ="$(=GetFieldSelections([Groups]))";

When I use a bar chart to show result of the formula and set alternate state to As1 for the chart, the formula works.

When I want to compare two groups, I need to set bar chart to default state, and write formula like this:

But it does not work.

If I create formula like this:

It works but the bar chart does not show correct value.

If I set formula like this:

It works. But if I set formula like this:

It does not work.

What I need is that when I select one sub field of Groups I get the correct value in chart.

How should I define set analysis and expression so I can get what I need?

Thanks.

topic Multiple Alternate states - set analysis for default state chart in App Development