I have two number type Charts in my Dashboard
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
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.
| Topic | Replies | Views | Activity |
|---|---|---|---|
| Comparing Two Columns in Mongo Charts (Using Table) | 1 | 770 | May 2024 |
| Mongodb Atlas Charts: Adding date filter on history collection | 3 | 574 | Jun 2024 |
| Chart SDK - ‘preFilter’ property is not available for createChart() method in @mongodb-js/charts-embed-dom | 3 | 295 | Jul 2024 |
| Adding true and false boolean values to charts | 0 | 28 | Nov 2024 |
| Charts calculated field based on field existence | 0 | 14 | Dec 2024 |
