Rename column name dynamically using variable

[susmita_k]

Is there a way to rename a field dynamically ? I am creating a comparison dashboard, and need to show the column like column_prod, column_cap. But the environment is a variable and chosen by user. I am not able to rename the column using a variable. Any help is really appreciated.

[Akhil-Jayendran]

Hello @susmita_k ,

I think it is technically possible to use a variable in a dashboard, and this variable can be used to rename the field, something like this.

Used sample dql is 

  data record( a= "test", b= 3),
     record( a= "test1", b= 7),
     record( a= "test", b= 13),
     record( a= "test2", b= 10),
     record( a= "test3", b= 31),
     record( a= "test2", b= 45)
  | filter a==$Variable1
  | summarize  `$Variable1`=sum(b)

https://docs.dynatrace.com/docs/analyze-explore-automate/dashboards-and-notebooks/dashboards-new/com...

I’m not certain about your requirement, but maybe you can think in this direction or provide the exact requirement along with a sample query so we can look into it.