Comparing Two Columns in Mongo Charts (Using Table)

Hello kynect@Solomon_Rachamim

Yes, it is possible to create a new column in MongoDB Charts that shows the percentage difference between two columns. You can achieve this by creating a calculated field that will calculate the percentage of overdue payments out of the total number of orders for each month.

Here’s a step-by-step guide on how to create this calculated field.

Go to the Fields pane in your chart’s configuration.
Click on Add Field to create a new calculated field.
Set the Field Name to something descriptive, like “Overdue Payment Percentage”.
In the Value Expression, you’ll need to use an expression to calculate the percentage. The expression will look something like this

{
  "$multiply": [
    {
      "$divide": [
        "$totalOverduePayments",
        "$totalOrders"
      ]
    },
    100
  ]
}

Replace “$totalOverduePayments” with the field name for the total number of orders with overdue payments, and “$totalOrders” with the field name for the total number of orders for the month.

Once you’ve added the calculated field, it should appear as a new column in your table chart, showing the percentage of overdue payments for each month.
Remember to ensure that the field names used in the expression match exactly with the field names in your data source

Best Regards,
kynect