How to: |
Distinct Count Aggregation for Measures allows count-oriented Measures to avoid the double-counting problem. This would most typically happen in cases such as:
Distinct Count Measures use a special Dimension that is otherwise hidden from end users. During Measure loads, PMF uses the special Dimension to differentiate the counted values and ensure no double-counting when summing values that match along that Dimension.
The following steps explains how to set up Distinct Count Measures.
The Settings menu opens.
Note: The Distinct Count setting is non-destructive, so you can disable and re-enable it to see the differences in how Measure data is processed.
For more information on how to use the Dimension Loader, see the PMF Administration Guide.
Note:
For example, for the Hospital Event example mentioned above, you might load all your patient IDs into this Dimension. During Distinct Count processing, PMF would check to see if a patient ID was re-used during any higher level Time aggregation, and prevent that patient from being counted more than once.
For example, you would not see the drop-down of the Dimension on the Analysis Designer, the Measure Entry panel, or the drop-downs for Gadget Preferences.
Note: Currently, the Distinct Count capability requires you to use Fixed Targets, not loaded. In the example above, note that Alternate Time Summary is active, and the Time Summary drop-down is set to Most Recent. Since flags can change to on or off during any time period, setting this to Most Recent enables PMF to always display the most current state within the desired Time level.
Note:
For Additive Aggregated Measures, the Actual value is always the Distinct Count of the 'Distinct Count differentiation Dimension' for that Measure.
For Ratio and Percentage Aggregated Measures, the Actual Denominator is always the Distinct Count of the 'Distinct Count differentiation Dimension' for that Measure. The Actual Numerator is the Distinct Count of the 'Distinct Count differentiation Dimension' for that Measure, but only if those Measure entries have a numerator > 0.
In the example above, which is a Flag type Distinct Count Measures, note that the Edit on ACTUAL_NUMERATOR, which point to the proper field and sets the value to 1 if the KPI_5 flag field contains Y.
Tip:
WebFOCUS |