Numeric columns - opetations between columns

(Raphael Vau) #1

Hi everyone!

I am trying to get a specific table and I need to do operations with the primary columns I am getting (like cola+colb/colc) to create a kpi. I'll try to explain it with an example.

The data I am receiving are purchases from a lot of shops, and I am trying to create a table (at shop level) in which I am creating a KPI that would be something like : (

(visits_that_purchase something/clients_entering_to_the_site) * count(distinct) (clients)

This would give me a Kpi to measure the importance of each shop and direct corrective measures towards it.
The problem is that I am trying to do it using a table visualization but I am not sure I can do operations between columns.

Using the Visual Builder, I managed to get the % of visits that purchase something, but I cannot multiply that number * count(distinct)(clients)...
Also, clients and visits don't come at the same events, so it has to be done at a "shop" level.

Is there a way to do it?


(Spencer Alger) #2

Unfortunately, there isn't any way to calculate values based on the columns in a table. There might be a way to do something similar to what you're trying with pipeline aggregations but I don't think there is any way to calculate this column today in Kibana. Something like a "calculated columns" feature in Kibana might be enough for this, if you're interested in such a feature I suggest filing a feature request. I would have sworn one already existed but I can't find it now...

(Raphael Vau) #3

Hi Spencer!

I managed to do something like that in the table of the Visual Builder by using the Math aggregation. The only problem is that I'd like to group by two different terms but I don't think it can be done.
But I'll fill the request for sure, thanks for the advice :slight_smile:

Have a nice day!

(system) #4

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