Problem Dividing Metrics in TVSB

Elastic Stack Kibana
1

Hi,

I am recent to Kibana and I am having issues displaying a metric which is the result of a division of two fields. I am trying to do this in TVSB and this is the current setup I have:

doubt_kibana
doubt_kibana1888×682 36 KB

I know the count of device_id is around 187k and the count of household_id is around 167k. So I expect the metric to show 1,2 but at the time it says " No results found". What am I doing wrong?

Thank you.

2

This might be a bit easier to do in Lens with a custom formula -

image
image672×1414 57.9 KB

3

Sorry but how do I add a custom formula in an axis in Lens?
I do not think I have that menu. I have these options for the vertical axis.
Captura de ecrã 2022-02-25 155553

4

ah, this was added at version 7.14. Are you able to upgrade?

5

I have an enterprise edition. I cannot upgrade from the version I have at the moment. Is this still doable?

6

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