Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello QS experts,
I am dealing with a bar chart. Here is the outcome when I only select March 2024.
I'd like to add an Alternative Dimension, which is the autocalendar.YearMonth.
After adding the dimension, it seems that it couldn't fit with my current measure expression.
The accumulation should be 359, but it shows 16 instead.
Is there any way add another expression to fit with the dynamic dimension?
The expressions I am using are:
Measure:
=
Aggr(
Count({<Date={"<=$(=Today())"} >} ID),
Class , (Date,NUMERIC,ASCENDING)
)
Dimension:
Date, Class
