Grafanav8.1.1: Issues with panel's column display with Gauge and Threshold, working with v7.3.7

  • What Grafana version and what operating system are you using?
    v8.1.1 and v7.3.7

  • What are you trying to achieve?
    data visualization using gauge and thresholds in panel.

  • How are you trying to achieve it?
    Gauge with thresholds working correctly with v7.3.7 but the same dashboard migrated to v8.1.1 the thresholds are not working as expected.

  • What happened?
    v8.1.1 is not able to apply the threshold over gauge type cell display mode.

  • What did you expect to happen?
    thresholds to work properly on gauge type cell display mode.

  • Can you copy/paste the configuration(s) that you are having problems with?
    yes, attached screenshot.
    Grafana v8.1.1 column and override configuration:-

Grafana v7.3.7 column and override configuration:-

Image Grafana v7.3.7 shows the column ‘Connect Rate’ displayed as unit percent (0-100) with mode LCD Gauge and threshold applied on the values to show progress.
The same dashboard then imported in another instance of Grafana with version v8.1.1 with no change in dashboards, data source, the applied configuration of unit, cell display mode with threshold is not working on the column ‘Connect Rate’.

Hi @sdatta

Can you share your panel JSON?

Have you tried setting an override property for that field and setting the max value to 100?

I think the issue here is that in Grafana 8 we added a lot of new functionality with custom overrides, but that moved some things, and we are still discovering edge cases in the JSON migration.

Hi @mattabrams
Setting the max value override property to 100 solved the issue in v8.1.1

Below is the sample panel JSON body -
[{
“columns”: [{
“text”: “CHANNEL”,
“type”: “number”
}, {
“text”: “CHANNEL NAME”,
“type”: “number”
}, {
“text”: “AGENT CALLS”,
“type”: “number”
}, {
“text”: “TOTAL CALLS”,
“type”: “number”
}, {
“text”: “CONNECT RATE”,
“type”: “number”
}, {
“text”: “SALES”,
“type”: “number”
}, {
“text”: “REVENUE”,
“type”: “number”
}, {
“text”: “COMM. AMT.”,
“type”: “number”
}, {
“text”: “CLOSING %”,
“type”: “number”
}, {
“text”: “AVG. REVENUE”,
“type”: “number”
}, {
“text”: “PIF %”,
“type”: “number”
}
],
“rows”: [[210, “ABC”, 3.0, 28.0, 10.714285714285714, 1.0, 149.99, 15.0, 33.33333333333333, 149.99, 100.0], [211, “BCD”, 30.0, 649.0, 4.622496147919876, 2.0, 298.99, 55.0, 6.666666666666667, 149.495, 100.0], [203, “EFG”, 16.0, 34.0, 47.05882352941176, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0]],
“type”: “table”
}
]

The JSON data source is same for both the versions. The ‘ConnectRate’ or ‘Closing%’ is of type number.
Thank you for your input.

Regards,
Sudeep

1 Like