How to show value with comparatively large difference in bar chart.

[Aryasmank]

Hi all,

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.

Thanks,

Mayank

[Or]

Set a maximum (static or using a formula) rather than using the automatic range. In the below, C is 100,000: