topic Re: How to calculate relative values in stacked bar chart? (by expression) in App Development

How to calculate relative values in stacked bar chart? (by expression)

DSDD — Sat, 16 Nov 2024 17:51:52 GMT

Dear community,

i am struggling with set analysis syntax. I want to calculate relative values of Order-Number in a weekly bar chart.

Lets say WEEK is my field for week-date and GROUP1 my field for categorical values.

Pleas help me to find the syntax for the order-counts per week, while WEEK and GROUP1 are dimensions?

I thought COUNT(ORDER_NO)/COUNT(TOTAL <WEEK> ORDER_NO)*100 would do, but obviously not.

WEEK is saved in a variable v_time and may by user selection exchanged with MONTH. The same for GRPOUP1. There are several selectable grouping fields in a second variable v_group.

Re: How to calculate relative values in stacked bar chart? (by expression)

MayilVahanan — Sat, 07 Nov 2020 01:56:18 GMT

HI @DSDD

Try like above

COUNT(ORDER_NO)/COUNT(TOTAL <$(v_time)> ORDER_NO)*100

Hope, v_time is exactly same like ur dimension (Field) name.

Re: How to calculate relative values in stacked bar chart? (by expression)

DSDD — Sat, 07 Nov 2020 07:30:11 GMT

Hi MayilVahanan,

i tried it like you mentioned, before and it works in the case of a barplot where i select as bar dimension my field GROUP1.

But:

If the two categorical fields GROUP1 and GROUP2 are within a variable v_parameter, which is contained as $(v_parameter) as bar grouping dimension, then COUNT(ORDER_NO)/COUNT(TOTAL <$(v_time)> ORDER_NO)*100 does not work anymore. Both groupings are ignored and COUNT(TOTAL <$(v_time)> ORDER_NO) counts all exising orders without any grouping.

Why? And how does the syntax have to be changed?

Thank you very much for your help