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?