A Workbench report with grouped summary by provider and location needs to incorporate sub-groups for specialty and sub-measures like cost variance. For advanced aggregation, what in Summary tab?
A.
Multi-level grouping with nested aggregates (e.g., avg of sum)
When a Workbench report groups results by provider and location and also needs sub-groups for specialty and sub-measures such as cost variance, the Summary tab is configured with multi-level grouping and nested aggregates. Each level of grouping divides the results further, and the aggregate functions are applied at each level, which makes it possible to calculate, for example, the average of a sum. The first option is correct. A single level of grouping would not provide the sub-groups. The Explore tab supports visualizations after the report has been run but does not build the structure into the template. Linking to SlicerDicer would involve a different tool and a different data source. Developers should consider the order of the grouping levels, since it determines how the results are presented and which totals are visible. They should also check that the aggregates are meaningful at each level, because an average of averages can misrepresent the data when the groups differ in size. Testing the report against a known sample confirms that the figures are correct.
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit