Pivot table format

asuryasudheer · January 13, 2023, 11:17am

Hi,

I have data in the table format as shown below

I want the table format as below

Is it possible in grafana, if yes how to proceed

yosiasz · January 13, 2023, 5:37pm

Hello

It is possible

yosiasz · January 13, 2023, 7:34pm

But it would be better to do it on the database side . What is your database

asuryasudheer · January 16, 2023, 5:01am

Hi Yosi,

Thanks for your reply. My DB is SQL server

yosiasz · January 16, 2023, 5:21am

Its more of a sql issue thqn a grafana issue.

I would ask here