"Colors" shows limited options based on Beast Mode

WGoeringer

I used Rank & Window ETL to Rank Districts 1-46 based on a performance value. I need to use the "Colors" feature in Analyzer to color code rows based on a "Tier" I created in a Beast Mode, which is calculated based on percentile.

The Beast Mode is as follows:

In the preview, this works. Ranks 1-11 are D, 12-23 are C, etc.

But when I go to add a Color rule, it only gives me two options. Is this a bug?

nmizzell

The color rules may not recognize the aggregated formulas in the pivot table.

For example, if each point in your dataset ranks A or B, then the color rules will only show these options, even if the aggregation formula in the pivot table ranks some groups of data points as C and D, in addition to some groups that are ranked as A and B.

If this is the source of the problem, the solution is quite simple:

Instead of using a beastmode to calculate the aggregated table, simply do the calculation in Magic ETL and output the table in pivoted format from the beginning. This will ensure that each data point is ranked correctly on the source dataset and does not rely on the aggregated formulas in the pivot table for the color rules.

nmizzell

Hey W,

Could you share a screenshot of your full analyzer page?

If a filter is applied that excludes categories C and D, they will not appear as an option for color rules.

Another thing that could cause this is if categories C and D are not present when the calculation runs. i.e. if none of your data points are less than or equal to .59

WGoeringer

Hi @nmizzell, I would prefer not to share the full page due to company metrics. However, in the preview, all 46 Districts are present and all of them have Tiers A-D as the Beast Mode calculates.

1-11 are showing D

12-23 are showing C

24-34 are showing B

35-46 are showing A

In my original post, the screenshot shows Tiers C and D present in the preview, but only A and B are showing up in the Color Rule list. I do not believe a filter is affecting this.

nmizzell

The color rules may not recognize the aggregated formulas in the pivot table.

For example, if each point in your dataset ranks A or B, then the color rules will only show these options, even if the aggregation formula in the pivot table ranks some groups of data points as C and D, in addition to some groups that are ranked as A and B.

If this is the source of the problem, the solution is quite simple:

Instead of using a beastmode to calculate the aggregated table, simply do the calculation in Magic ETL and output the table in pivoted format from the beginning. This will ensure that each data point is ranked correctly on the source dataset and does not rely on the aggregated formulas in the pivot table for the color rules.