Grafana version: Grafana v10.2.0
Operating system: MacOs, i am using Grafana in google chrome
-
I want to use dynamic column names as table headers and then export the table as csv.
-
I have created variables in Grafana-dashboard using below query and then used the query output as header of a column in table with the help of override variables.
-
Dynamic columns worked perfectly in a table using dashboard and override variables. However, when i try to export the table to csv, then the headers are replaced by the variable names.
-
Dynamic columns created for the table will stay exactly the same during the csv export (in Inspect option).
-
Configurations:
Query variable: header_one_week_one_year_ago
Query:
SELECT 'CW ’ || EXTRACT(WEEK FROM CURRENT_DATE - INTERVAL ‘53 weeks’) || ’ ’ || EXTRACT(YEAR FROM CURRENT_DATE - INTERVAL ‘53 weeks’) AS header_one_week_one_year_ago;
Panel query:
select
one_week_ago_2019 as “header_one_week_one_year_ago”
from
schema.table_name;
Override variable:
${header_one_week_one_year_ago}
-
No errors on Grafana UI.
-
I did not follow any online instructions. I have tried to google and check inside community, but could not find anything relevant.
Thank you. I am looking forward for your responses.