we are trying to create a Heat map to reflect last 10 pipeline builds for environments (Dev, Test, Prod)
In the metric section we had chosen the count , in the x axis we had taken the Date histogram and build finish time as field , and in the Y axis we have selected aggregation as terms --> environment (Dev, Test, Prod). now in order to get the last 10 builds per environment we selected the Split chart and in column --> terms --> id (build) , but we are not getting the appropriate heatmap .
My questions is whether I am going in the right direction or some other approach is required ??
do we need to have a scripted field for build results ??
Any pointers ??