How to perform calculation for the unique count document in kibana?

Greetings!

Is there any possibility to do the calculation for the unique count document in kibana?

Thanks.

Yes, there's a unique count metric aggregation in Kibana visualizations.

image

Hi @LeeDr, thanks for replying.

Kindly advise on the method to achieve the condition as below:

I have a field "test" which consists of 'G','P' and 'N'. I would like to obtain the unique count of timestamp for this field (figure below) then do the calculation: ('G'+'P')/('G'+'P'+'N').
Is this possible to achieve?
image
Thank you.

I'm back from vacation. If you haven't solved this yet I can try to help. The only visualization that lets you do calculations like that is the "Visual Builder", also known as Time Series Visual Builder or TSVB for short.

There's a bunch of Discuss posts about visual builder doing ratios of values. Here's the search results;

https://discuss.elastic.co/search?q=visual%20builder%20ratio%20category%3A7

Please let me know if you need help.

Regards,
Lee

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