Renaming field after Outer join transformation

Grafana
1

Hi,

I’ve got an index “heartbeat--” in my Elasticsearch database where a heartbeat agent sends its availability tests. I’ve been working on a yearly table showing average availability with applications names presented by row and months by column. I’ve made a query for each month where “application.name” is grouped by Terms and where a Bucket Script metric calculates the availability percentage based on two other metrics.

Capture2
Capture2868×589 46.7 KB

In the Transform section, I’ve created a “Outer join” transformation for my applications to be assembled in the same table. I’ve also added a “Filter by name” transformation in order to hide metrics used by the Bucket Script calculations. The result is almost successful except I get the same name “Bucket Script” for each of the columns and I can’t rename them. When I create an “Organize fields” transformation in order to rename the fields, it simply doesn’t work.

Capture1
Capture1866×809 56.7 KB

I’m surely doing something wrong but I can’t see what.
Any Idea ?

2

Hi,

did you try to add one more transformation (Organize fields) it should allow you to rename.

Other solution is using tags as alias in the query.

Good Luck

3

Thank you wlargou for your help.
Indeed, the “Organize fields” Transformation works properly. The problem I met was that I made an update from Grafana 6.x to Grafana 7.x. After that, I didn’t noticed that the current “Table Visualization” on the right panel was unselected. There was no selection actually. So I was still probably pointing to an inexistant version of the Table Visualisation. After re-selecting the Table visualization, all is ok now. I can rename any field, no matter whether there is an Outer Join transformation before or not :slight_smile:

1 Like
4

This topic was automatically closed after 365 days. New replies are no longer allowed.