AGGREGATE BANDING

Futrix Aggregate Banding is a type of Segmentation Dimension which allows the data to be classified by segments (bands) based on the totals of a selected Measure, when the data is pre-summarized by a selected Dimension.

Aggregate Banding is similar to the Detail Banding Dimension functionality, which also allows the data to be classified by bands based on a Measure, but in case of the Detail Banding Dimensions, the bands are based on the Measure value at the detail level, whereas for Aggregate Banding, the data is pre-summarized by a specific Dimension first. Aggregate Banding is also similar to Analysis Groups functionality, which is another type of Segmentation Dimension, but where Analysis Groups split the data always into 2 groups (“Yes” and “No”), Aggregate Banding can split the data into any number of groups (i.e. bands).

Aggregate Banding can be created, shared, modified and applied by users via the Futrix Web Interface and saved as Global, Group, or Personal. After the Aggregate Banding dimension has been created, it can be applied to any Viewpoint if its underlying Data Source contains the Aggregation Dimension. Aggregate Banding Dimensions can also be edited including adding filters at any time, independently of any Viewpoint.

The use of Aggregate Banding does not require any changes to the underlying Data Source, Futrix Metadata or any involvement of a Futrix Administrator. End users can create, share, modify and apply Aggregate Banding Dimensions using the Futrix Web Interface.

aggregate banding2

EXAMPLES

  • What is the total Paid Amount that is generated by High Cost Claimants (where High Cost Claimant is a Patient with over $30,000 in total claims).
  • How much is the total Paid Amount and how it compares between Claimants that had different number of Inpatient Admits (1 vs. 2 vs. 3 vs.more than 3).
  • How does the number of Rx Prescriptions compare between Claimants that have different number of Inpatient Admits (1 vs. 2 vs 3 vs. more than 3).