Hi Looker team,
I’ve set up a metric in Looker Studio called ROI = (x - y) / y
The result is wrong, i.e. In the image in the first row should be = 0.0527 instead o 7,33
Furthermore, the result of 1/y it´s also wrong but y/100 gives the right answer.
Could somebody help me?
Thanks in advance.
any solution for this? the same problem here
I think this the wrong forum for Looker Studio questions?
But I think the solution is to use the SUM() function in your formula:
( SUM(recupero) - SUM(total_cost) ) / SUM(total_cost)