Calculate ratio beetwin count and unique count

Elastic Stack Kibana
1

Hello,

I have a list of tickets for a computeur support.
I would have in a tab the ratio beetwin the count of exchange and the unique count of ticket number, for different typologies, like that:

image

Is it possible in a tab ?

thanks

2

Hello,

I suppose this topic is related to you. Only with kibana seems impossible unfortunately, but transform may be a possible solution.

3

Hi @Fred59 ,

another option you can consider is Lens formula:

unique_values( myField ) / count()

to know more about Lens Formulas you can have a look at the guide, which includes some nice examples: Create visualizations with Lens | Kibana Guide [7.16] | Elastic

1 Like
4

The option looks great. Thanks for adding that.

This is an example on kibana_sample_data_flights.

image
image3289Ă—658 95.9 KB

6

thanks but it's desable on my hoster :frowning:

7

thanks but it's desable too on my hoster :frowning:

8

Which version of the stack do you have?

9

I think i will use that:

It should be possible to install that on my hoster :slight_smile:

10

Kibana 6.8.23

11

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