Get an average value of the sum of two fields

[Gokul_Raj]

I have two number type Charts in my Dashboard

1. Sales Amount
2. Quantity

I need to divide the result of the two number charts and get the quotient
(Amount) / (quantity)
This quotient has to be displayed as another number type chart

Is there a way we can do this

[tomhollander]

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.