Mismatched Aggregation Issue While Using a Dimension Field

[duncan]

Hello @simantsah !

Have you tried doing something similar to the post below and turning {stagename} into an aggregation?

Calculate Field - Division - Mismatched Aggregation

Hi, I am trying to create a calculated field which is essentially {Total Fee Value}/{Total Payment Received Onwards}. It is just to get an Average of the Total Fee Value per day as my visual is just a table which is grouped by a date and has many custom calculated field values. The {Total Fee Value} field is a sum of 4 other calculated fields which all look like this with different states: ifelse({CaseID Row Rank} = 1 AND (state = ‘State 1’ OR state = ‘State 2’), {totalfee}, 0) The CaseID Ro…