SYMPTOM:
The user has created a report with the quarter attribute, the cost metric, and the average subtotal as seen below:
The user would like to create a metric that displays the average subtotal value for each quarter.
STEPS TO REPRODUCE:
1. Create a Sum(Cost) metric with the level set to Quarter and grouping set to none.
2. Create a second metric defined as Count(Quarter) with the level set to Quarter and grouping set to none.
3. In the metric definition, Right click the Count function and select Count parameters. Set the Distinct parameter to true and the Fact ID parameter to use the desired fact table.
4. Create a third metric that is the first metric divided by the second metric. This will give the average subtotal for each quarter row as seen below:
