hi!
I have a data in one table:
date, amount, cost
2024-10-01, 100, 20
2024-10-03, 100, 25
I am showing that data in the table in Looker and adding new calculated field ROAS = amount/cost:
date, amount, cost, ROAS
2024-10-01, 100, 20, 5
2024-10-03, 100, 25, 4
I want to have a summary, but not as a SUM of all fields, but SUM(amount), SUM(cost) and ROAS as a SUM(amount)/SUM(cost)
How I can do that?
You should replace the formula of your calculated field by SUM(amount)/SUM(cost). It is the good way to go for reach row and the summary calculation.
Mehdi
User | Count |
---|---|
4 | |
1 | |
1 | |
1 | |
1 |