topic Re: show % evolutuion different products in App Development

show % evolutuion different products

fran_perea — Mon, 13 Nov 2023 14:37:31 GMT

I have several products, each of them has a % of sales.I want to display the evolution in another chart. But when i try to do it the cahrt is like this one:

As you can see the % doesn´t match between graphs. The Set Analysis formula is the same.

(sum({<[Operation]={'Sale'},Year,MonthYear, [Wallet ID]={'A','B', 'C', 'D'}>}Amount)
-
sum({<[Operation]={'Return'}Year,MonthYear, [Wallet ID]={'A','B', 'C', 'D'}>}Amount))
/

(sum({<[Operation]={'Sale'},Year,MonthYear, [Wallet ID]={'A','B', 'C', 'D'}>} Total Amount)
-
sum({<[Operation]={'Return'},Year,MonthYear, [Wallet ID]={'A','B', 'C', 'D'}>} Total Amount)

Any guess what im doing wrong?

Thanks

Re: show % evolutuion different products

marcus_sommer — Mon, 13 Nov 2023 14:59:43 GMT

You may try it with:

... Total <Year> Amount)

to consider at least one dimension - the Year - by the calculation (depending on requirement you may add Product respectively switch between dimensions).

Re: show % evolutuion different products

fran_perea — Mon, 13 Nov 2023 15:05:55 GMT

The bar chart is the good one, the % of the Blue one should be 76% in 2023, not 25%.

With the solution you suggested there is an error in the expression.

Re: show % evolutuion different products

marcus_sommer — Mon, 13 Nov 2023 15:17:34 GMT

There should be no error - did you an appropriate adjustments of the total statements within the expression?

Re: show % evolutuion different products

fran_perea — Mon, 13 Nov 2023 15:21:50 GMT

Yes, my bad. I didn´t introduced it properly. Now is working fine.

Thanks a lot!