I have data having a large difference between the two values.
Measure used: Dual(replace(replace(replace(INTERVAL(max(End_Date)-Created, 'D@ hh# mm&'), '@', ' Days '), '#', ' Hours '), '&' ,' Minutes '), INTERVAL(max(End_Date)-Created, 'D@ hh# mm&'))
basically I'm taking the time difference between two timestamps and as per requirement, I'm converting them to ##Days ## Hours ##Minutes format.
In this case, there is a large difference between Process 7 and the other Processes.
Please suggest a solution to this.
Set a maximum (static or using a formula) rather than using the automatic range. In the below, C is 100,000: