Hi All,
I'm not able to compare the value of bars in the combo chart. The level of all three bars is similar.
Please suggest a feasible solution to this issue.
these are the measure I've used.
Bar 1: Dual(Replace(Replace(replace(Interval(Max(End_Date-Start_Date), 'D@ hh# mm&'), '@', ' Days'), '#', ' Hours'),'&',' Minutes'), Interval(Avg(End_Date-Start_Date), 'D@ hh#'))
Bar 1:Dual(Replace(Replace(replace(Interval(Avg(End_Date-Start_Date), 'D@ hh# mm&'), '@', ' Days'), '#', ' Hours'),'&',' Minutes'), Interval(Avg(End_Date-Start_Date), 'D@ hh#'))
Bar 1:Dual(Replace(Replace(replace(Interval(Min(End_Date-Start_Date), 'D@ hh# mm&'), '@', ' Days'), '#', ' Hours'),'&',' Minutes'), Interval(Avg(End_Date-Start_Date), 'D@ hh#'))
Basically, I'm comparing the maximum, average, and minimum time difference between two dates, and as per requirement, I'm converting them to ##Days ## Hours ##Minutes format.
![Aryasmank_0-1672844812355.png Aryasmank_0-1672844812355.png](https://community.qlik.com/t5/image/serverpage/image-id/97238iC761BCFAAFC17027/image-size/medium?v=v2&px=400)
Thanks,
Mayank