Hi @Gokul_Raj, yes this kind of thing is possible but it requires a custom pipeline.
Here is an example using the IoT sample data set. In the query bar I calculate the sum of the stepsTotal field and then count all fields with $sum: 1. Then I have a calculated field that divides one total by the other.
2 Likes