One Metric Set: 2 Independent Metrics

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

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