How to compare two table columns

Solomon_Rachamim · 2024-05-08T05:27:08.119Z

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

Avinash_Prasad · 2024-05-08T05:52:24.508Z

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.