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

t-gilchrist — Tue, 04 Jun 2019 14:54:20 GMT

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

Re: Aggr expression in Combo chart line graph displaying last "date" instance instead of f

t-gilchrist — Tue, 04 Jun 2019 14:59:09 GMT

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

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

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

Re: Aggr expression in Combo chart line graph displaying last "date" instance instead of f