Get an average value of the sum of two fields

MongoDB Atlas MongoDB Charts
1

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

2

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.

image
image1096×657 35.1 KB

2 Likes