I have json data like this:
[{“c_ca”: “4”, “c_pct”: “PCT1”, “c_line”: “L1”, “2025-11-01”: 3, “2025-11-02”: 3, “2025-11-03”: null},
{“c_ca”: “3”, “c_pct”: “PCT1”, “c_line”: “L3”, “2025-11-01”: 1, “2025-11-02”: 1, “2025-11-03”: null},
{“c_ca”: “4”, “c_pct”: “PCT2”, “c_line”: “L1”, “2025-11-01”: null, “2025-11-02”: 2, “2025-11-03”: 2},
{“c_ca”: “2”, “c_pct”: “PCT2”, “c_line”: “L4”, “2025-11-01”: null, “2025-11-02”: 2, “2025-11-03”: 2}]
I just want to display this data within a grafana dashboard, but I am not sure of the best way to do this.
I want display:
You can use infinity and business table (for custom html) to get the vertical column name payout for the last 3 columns
Dear yosiasz,
I am using the free version of Grafana version 11.1.0, so I cannot use Business Table with Custom HTML. Is there any other way to achieve this?
I really appreciate your help.
You can indeed use business table in enterprise and OSS version of grafana
I use HTML Graphics to display json data, but it does not display data:
code in HTML:
it was recommended for you to use infinity and business text
I am using a PostgreSQL database, and the number of columns is not fixed; it depends on the data selected from a combobox
Example: choose from 2025/11/01 to 2025/11/01, there are 4 columns : c_ca, c_pct, c_line, 2025-11-01.
choose from 2025/11/01 to 2025/11/03, there are 6 columns : c_ca, c_pct, c_line, 2025-11-01, 2025-11-02, 2025-11-03.
I want it displays:
Is there a way to display the data like that? I am using the OSS version.
Business text is your solution. Read the docu on that and with some html and css tricks you can get exactly what you want
unfinished but it kind of shows you what is possible.
sorry but i aslo have 1 problem with json for Bussiness Text, pls help me
i created 1 Variable with name jsondata
data of it :
it seem:
in dashboard : already get jsondata, but can not value of jsondata in html …
pls help, thank you
The SQL query returns data, but why is the data not displayed?
Is there a problem with my Business Text?
How can I loop through each element (c_pct, c_line, c_ca, 2025-11-01, 2025-11-02, …) inside the data?
yosiasz
12
The documentation for business text should help explain how to do that
yosiasz
13
look at the following real carefully.
