topic Re: Filter selection with alternate fields in App Development

Filter selection with alternate fields

Baavik — Fri, 15 Nov 2024 21:04:10 GMT

Hi Team,

I have data of few scores for different items for different staff id. we need to compare month-wise individual score and get the count of staff who increased/decreased/same in their scores.

For this, I have created 2 alternate states Group1 and Group2 for different month selections and when I have to compare the individual scores, I am getting the total sum of all the scores of that month selection, used the below expression -

If(sum({<Date={'$(=Date(Max({GROUP1}Date),'YYYY-MM-DD'))'}>}Score)<
sum({<Date={'$(=Date(Max({GROUP2}Date),'YYYY-MM-DD'))'}>}Score),Count([Staff ID]))

Tried with only/count/distinct but no luck.

If score of selection 1 month < score of selection month 2 - Increase

If score of selection 1 month > score of selection month 2 - Decrease

If both scores are equal - Same.

All these status need to be represented in a stacked bar chart with different colour codes.

Attaching images for your reference.

Any leads is much appreciated !!! TIA !!

Re: Filter selection with alternate fields

vincent_ardiet_ — Wed, 14 Feb 2024 08:30:08 GMT

I don't understand what you are trying to represent in your bar chart and what is your issue exactly.

Re: Filter selection with alternate fields

Baavik — Wed, 14 Feb 2024 10:21:05 GMT

Hi @vincent_ardiet_ ,

Apologies!! Ignore the values in the bar chart.

I need to represent the count of staff id for those who are in increase/decrease/same states with different colour codes in the bar chart.

As per the above data ,comparing scores of selection 1 and 2, count of staff id should be like -

5 in same (grey colour), 4 increase (Green colour) and 1 decrease(Red colour).

Hope this is clear !! Thanks!!

Re: Filter selection with alternate fields

vincent_ardiet_ — Wed, 14 Feb 2024 10:27:27 GMT

You can create 3 measures, one for each status for example.

Re: Filter selection with alternate fields

Baavik — Wed, 14 Feb 2024 11:47:35 GMT

@vincent_ardiet_

Yes, that is where I am facing the issue. I have used the below expression for Increase state (if individual score of selection1 is < individual score of selection 2) as-

If(sum({<Date={'$(=Date(Max({GROUP1}Date),'YYYY-MM-DD'))'}>}Score)<
sum({<Date={'$(=Date(Max({GROUP2}Date),'YYYY-MM-DD'))'}>}Score)

Group1 and Group2 are month selections , in that I need the month-end data, so have taken max(date).

Now this expression is summing up all the scores and comparing but I need individual score comparison.

Tried with only, count, but it didn't work.

Re: Filter selection with alternate fields

vincent_ardiet_ — Wed, 14 Feb 2024 13:31:21 GMT

Sorry I don't follow.
Could you illustrate with an example what you are trying to achieve?