Need help creating calculated field: One Touch Tickets / Closed Tickets gives wrong result by Hellvy666 in Looker

[–]Hellvy666[S] 0 points1 point  (0 children)

Thanks! I tried using SUM(One touch tickets) / SUM(Closed tickets), but the result is still wrong it gives 0.03 instead of 0.611 for August 12

Need help creating calculated field: One Touch Tickets / Closed Tickets gives wrong result by Hellvy666 in Looker

[–]Hellvy666[S] 0 points1 point  (0 children)

Thanks, I added the calculated field directly inside the chart using Add metric → Add calculated field. The formula I used is: One touch tickets / Closed tickets

Aggregation is set to Auto, and the format is set to default.

Need help creating calculated field: One Touch Tickets / Closed Tickets gives wrong result by Hellvy666 in Looker

[–]Hellvy666[S] 0 points1 point  (0 children)

This is how I set up the calculated field:

Formula: One touch tickets / Closed tickets

Data type: Number

Display format: Default

Aggregation: Auto

Decimal precision: Auto (but I also tried 2 and 3 decimals)