Doing computation on count aggregation in heatmap

Elastic Stack Elasticsearch
1

Hi,
I created a heatmap visualization. For the x-axis I have a date histogram, for the y-axis I have a "Terms" aggregation. For metrics I'm currently using the "Count" aggregation.

What I actually want is the "Count" divided by the sum of all "Count" aggregations of the same column. Mathematically, I want this:
Let c[i,j] = the Count of cell of column i and row j, then I want c[i,j] / sum_{k=1}^N c[i,k] where N is the number of rows.

Is this possible?

2

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.