Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I have created line chart with below scenario,
dimension: Week
Measure 1 : Sum(value)
Alternative Measure 2 (Past_10_weeks): SUM{<WeekID={">=$(=(Max(WeekID) -11))<=$(=(Max(WeekID)))"}>} Value)
I have included Median line for this chart using Measure1 expression, Now if i choose Alternative measure 2 , The median value is not changing, how to fix this for working with Alternative Measure 2.
Thanks in advance!
IF you are using a normal measure for your median presentation then you could try to use the GetObjectField.
Please observe that the function is not applicable if you are using the reference line found in the chart properties.