Aggr expression in Combo chart line graph displaying last "date" instance instead of first

[t-gilchrist]

Hello all, 

This is a sample table of my data

Equipment	DowntimeStart	DowntimeEnd	ShiftStart
Equipment01	4/20/2019 03:58:38 PM	4/21/2019 10:38:05 PM	4/20/2019 10:30:00 AM
Equipment01	4/20/2019 03:58:38 PM	4/21/2019 10:38:05 PM	4/20/2019 10:30:00 PM
Equipment01	4/20/2019 03:58:38 PM	4/21/2019 10:38:05 PM	4/21/2019 10:30:00 AM
Equipment01	4/20/2019 03:58:38 PM	4/21/2019 10:38:05 PM	4/21/2019 10:30:00 PM

Originally the formula used to count occurrences was as follows...

Count(Aggr(Count(ShiftStart),Equipment,DowntimeStart,DowntimeEnd))

But once used in a line graph I noticed in instances where the downtime spanned multiple days (like the table above) it was assigning the occurrence to the last day instead of the first day it occurred.

I thought this was possibly because of the order in which the data was loading into the table so I modified the formula to the one below but I'm still getting the same result.

Count( Aggr( Min(ShiftPlannedStart),Equipment,DowntimeStart,DowntimeEnd))

Any suggestions or explanation to why this may be happened is appreciated

Thanks 

[t-gilchrist]

ShiftDate is also relevant (Combo chart X Axis)

Equipment	DowntimeStart	DowntimeEnd	ShiftStart	ShiftDate
Equipment01	4/20/2019 03:58:38 PM	4/21/2019 10:38:05 PM	4/20/2019 10:30:00 AM	4/20/2019 12:00:00 AM
Equipment01	4/20/2019 03:58:38 PM	4/21/2019 10:38:05 PM	4/20/2019 10:30:00 PM	4/21/2019 12:00:00 AM
Equipment01	4/20/2019 03:58:38 PM	4/21/2019 10:38:05 PM	4/21/2019 10:30:00 AM	4/21/2019 12:00:00 AM
Equipment01	4/20/2019 03:58:38 PM	4/21/2019 10:38:05 PM	4/21/2019 10:30:00 PM	4/22/2019 12:00:00 AM