One Metric Set: 2 Independent Metrics

#1

Hi, I created a stacked bar chart with monthly trend, and I created a line graph with a 3 month moving average within the same metric set. I want the moving average to be the sum total of all products, however currently it’s broken out by product type. What do I need to do to just get the sum of total for the moving average and keep the stacked bar chart broken out by product?

Thank you.

LN

#2

As with many formulas, you can use the alignment hierarchy prameter in the formula used to control what the formula is applied over.

https://www.dundas.com/support/learning/documentation/design-view/formulas/standard/moving-average

In your case, it would be something like MOVAVG($Measure$, 3, $Months$)

2 Likes