Create a count of the total of desired metric

[Sugand]

Hi,

I have certain visualizations in dashboard based off condition's.
Example:
1> A metric of company numbers starting with number 1 and
2> A metric of emails staring with alphabet "a".

I want to create another visualization/metric "Sum of 1 and 2" where I would need to add/sum the count of metric of company numbers starting with number 1 AND metric of emails staring with alphabet "a".

Appreciate your input's on the same

[Marco_Liberati]

Hi @Sugand

assuming two fields company.name and email I think you could use Lens Formula to use filtered metrics on the count function like the following:

count(kql='company.name:1*') + count(kql='email:a*')

Would that work for you?

[Sugand]

@Marco_Liberati , would there be a solution to implement the same without Kibana Lens??

Appreciate your input's.

Thanks,
Sugand

[Marco_Liberati]

You can also use a TSVB metric, using a Count metric and a Panel filter as company.name:1* OR email:a*.