Heatmap Derivative aggregation not available

[ulfsa (Ulf)]

I enjoy using Heatmaps to visualize (non) change. In a heatmap of a thousand cells, the human eye can immediately spot any outliers.

I would like to visualize the delta of log data such as total bytes written. I would assume Derivative aggregation is the way to go here.

This works just fine with Line charts: for the Y-axis, I can select Aggregation to Parent Pipeline Aggregation --> Derivative and then choose the total bytes written document field.

For Heatmap charts, there are no Parent Pipeline Aggregations available in the dropdown for the Metrics Value -- only the Metric Aggregations such as Average, Count etc are available.

Is this proper behavior?

Stack: ES 7.8.0, Kibana 7.8.1.

Please advise. Thank you.

[ulfsa (Ulf)]

Additional info: at least in the documentation for 6.8, it shows Parent Pipeline Aggregations should be possible: https://www.elastic.co/guide/en/kibana/6.8/heatmap-chart.html.

Quote: You can add an aggregation by clicking the + Add Metrics button.

Unfortunately the Add Metrics button is not visible.

[flash1293 (Joe Reuter)]

This is a known feature request, but unfortunately it's not possible right now: https://github.com/elastic/kibana/issues/12171