I am using the Table chart type in Mongo db
The first column is the month
The second column is the total number of orders for the month
The third column is the total number of orders with overdue payments for the month
I want to create a fourth column that is the percentage difference between the third column and the second one
So for each month, I want a fourth column that is the (total number of overdue payments / total number of order for the month)
Is this possible in mongo charts, seems really really simple , just comparing two columns but I haven’t figured out a solution yet
Hi @Solomon_Rachamim,
This is possible using calculated fields. I have added column4(field name) based on a simple calculation as shown in the pic below.
You can see the documentation on how to add calculated fields here Calculate New Data Fields - Atlas Charts (mongodb.com)
