Conditional formatting for column chart in dashboard studio

[Racer73b]

Hi All,

I'm having trouble getting conditional formatting to work for a column chart in dashboard studio.   I want something pretty simple... I want the column "ImpactLevel" to be colored red if the value is less than 50, orange if the value is between 50 and 80, and yellow if the value is more than 80.  Impact level is the only series on the y2 axis of the column chart.

Here is the json for my chart:

"type": "splunk.column",

    "options": {

        "y": "> primary | frameBySeriesNames('_lower','_predicted','_upper','avg','max','min','volume','ImpactLevel')",

        "y2": "> primary | frameBySeriesNames('ImpactLevel')",

        "y2AxisMax": 100,

        "overlayFields": [

            "volume"

        ],

        "legendDisplay": "bottom",

        "seriesColorsByField": {

            "ImpactLevel": [

                {

                    "value": "#dc4e41",

                    "to": 50

                },

                {

                    "value": "#f1813f",

                    "from": 50,

                    "to": 80

                },

                {

                    "value": "#f8be44",

                    "from": 80

                }

            ]

        }

    },

    "dataSources": {

        "primary": "ds_9sBnwPWM_ds_stihSmPw"

    },

    "title": "HP+ Claims E2E",

    "showProgressBar": true,

    "eventHandlers": [

        {

            "type": "drilldown.linkToDashboard",

            "options": {

                "app": "sre",

                "dashboard": "noc_priority_dashboard_regclaimdrilldown",

                "newTab": true,

                "tokens": [

                    {

                        "token": "time.latest",

                        "value": "$time.latest$"

                    },

                    {

                        "token": "time.earliest",

                        "value": "$time.earliest$"

                    },

                    {

                        "token": "span",

                        "value": "$span$"

                    }

                ]

            }

        }

    ],

    "showLastUpdated": false,

    "context": {}