Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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