Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want the Duration information (green line) to be separated by each Machine name. Currently, the green line is in the middle for all machines and not separated by each MC point."
Justify_EquipmentNo_Display &' - '& Shift as Jus_MC,
Try this
Avg({<Year = {'$(=Max(Year))'}>} TOTAL <Jus_MC> Duration)
Avg(Duration) → per machine (separated green line)
Avg(TOTAL Duration) → overall reference line