Hi,
I am using Grafana 6.5.2 version and Linux operating system.
I am trying to show data using a script file on the dashboard, either in a graph or table format.
For both of them the big number values were rounding off and were shown with K as a suffix.
This is fixed for the graph chart, by setting the format value of y axis to none instead of short.
However, I am not able to correct the data appearing in the table chart.
It is still showing the data with K in the suffix and rounding off the numbers.
How do I remove the round off for the numbers.
Below is the json code which is used for generating the dashboard panel.
dashboard.rows.push({
title: 'Chart',
height: '300px',
panels: [
{
title: chartTitle,
type: ARGS.viewType, // graph or table
span: 12,
fill: 1,
linewidth: 2,
datasource: sourceName,
targets : [
{
"alias": "$measurement",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT " + property + " FROM " + queryThing + " WHERE $timeFilter",
"rawQuery": true,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
}
],
"legend": {
"rightSide":true,
"show": false
},
"yaxes": [
{
"format": "none", //changed from short to none for graph values rounding off to K
"label": unit,
"logBase": 1,
"show": true
},
{
"format": "short",
"label": "",
"logBase": 1,
"show": true
}
],
seriesOverrides: colorSetting,
tooltip: {
shared: true
}
}
]
});
Below is the sample image of the data populating in the table.
Thanks and Regards,
Bhushan Deshmukh