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.
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.
I’m surely doing something wrong but I can’t see what.
Any Idea ?