topic Re: Is it possible? in App Development

Is it possible?

ali_hijazi — Wed, 29 May 2024 13:18:25 GMT

Hello I got the following requirement:
I should create line chart with Month as dimension
there should be 2 expressions
1. Sum(measure)
2. Sum(measure) but for each month I got find the value of the measure the month that is one year back or 12 months back

as you can see here in 2023-11 the value is 3052
while in 2022-11 the value was 2675
but the 2675 value is displayed under 2023-11

knowing that the above photo is a drawing
is it possible to accomplish this requirement using set analysis?

Re: Is it possible?

Antoine04 — Wed, 29 May 2024 13:35:14 GMT

Hello,

You should use Month() function as dimension.

And create 2 measures.

One for CY : Year=Year(Today())

and one for LY : Year=Year(Today())-1

Regards

Antoine

Re: Is it possible?

ali_hijazi — Wed, 29 May 2024 13:50:32 GMT

but the dimension is the year-month
so under the same value of the dimension I want to display 2 values of the measure (CY and PY)
your suggestion dummy