Changing data options naming in dropdown for a Table with multiple queries?

Grafana v7.5.6

Hello, Im hoping this is a simple question, very new to Grafana and still in a learning process with everything.

I have two mysql queries to build a table.

Only the dropdown to select either query in the table displays all the column names. I have looked and can’t seem to see a configuration for this. Can the name I have called this query be called instead?

Thank you!

1 Like

You can use the transform function to deal this problem.

Would you know which transformation?

Could you done/achieve it? I want the same!

unfortunately not im afraid

I transform the name of column, but i only want to change the name on the dropdown not how it shows on the column of the table?