Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi experts,
I am trying to create cumulative line charts with accumulation function of my measure. This chart should not be impact by one of filters. Please see below example:
This chart above to show cumulative product ordered each financial month by financial year. I actually have two master calendars for financial year: master calendar for ordering date and one for shipping date. I would like to navigate different financial year for shipping date but not impact the chart above. Then I put set analysis in my measure as:
Sum({<[FinYear_shipping]= >}[product_count])
However, I found the chart still reflect to filter selection of shipping financial year if I apply accumulation for my measure. But it works perfect with actual measure for each financial month. How do I apply cumulative measure without filter impact?
Many thanks!
Yes it matters because the expression generated by QS (you can see the output expression expanding the Modifier menu) is adding functions like Above which needs to include your set analysis in order not to be sensitive to FinYear_shipping.
You can try like this (replace SERIES_FIELD and X_AXIS_FIELD with your fields):
Sum({<FinYear_shipping>}Aggr(RangeSum(Above(Sum({<FinYear_shipping>}Value),0,RowNo())),(SERIES_FIELD,(Numeric, Ascending), (Text, Ascending)),(X_AXIS_FIELD,(Numeric, Ascending), (Text, Ascending))))
Are you using the Modifier feature of QS with your measure or you are writing your own expression to cumulate values?
Hi Vincent,
I am using modifier feature of QS with my measure rather than defining it by own expression. Does it matter?
And I am not sure how to do cumulative values by expression..
Many thanks!
Try this
Aggr(Sum({<[FinYear_shipping]= >}[product_count]), FinYear_ordering, FinMonth_ordering)
Yes it matters because the expression generated by QS (you can see the output expression expanding the Modifier menu) is adding functions like Above which needs to include your set analysis in order not to be sensitive to FinYear_shipping.
You can try like this (replace SERIES_FIELD and X_AXIS_FIELD with your fields):
Sum({<FinYear_shipping>}Aggr(RangeSum(Above(Sum({<FinYear_shipping>}Value),0,RowNo())),(SERIES_FIELD,(Numeric, Ascending), (Text, Ascending)),(X_AXIS_FIELD,(Numeric, Ascending), (Text, Ascending))))