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.
Thanks,
Mayank