"Colors" shows limited options based on Beast Mode

WGoeringer
WGoeringer Member
edited July 11 in Beast Mode

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:

image.png

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

image.png

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

image.png

Tagged:

Best Answer

  • nmizzell
    nmizzell Contributor
    Answer ✓

    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.

Answers

  • nmizzell
    nmizzell Contributor

    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
    WGoeringer Member
    edited July 11

    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.

    image.png

  • nmizzell
    nmizzell Contributor
    Answer ✓

    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.

Categories