Calculating Maximum Wait Time as HH:MM

Wed, 25 Nov 2020 16:16:04 GMT

Am trying to use a concatenate script to report on the Maximum of 'TotalWait' which is calculated field within EDDATA based on calculation DateDiff(MINUTE,att.ARRIV_DTTM,att.DEPRT_DTTM) [TotalWait]

The following runs without error when I refresh data load, but when using Chart object to create a Pivot table the below value does not appear?? Is it to do with calculation or the data type format?

concatenate (SummaryED)

load

Campus as Campus,

Year as Year,

Qtr as Qtr,

Month as Month,

WeekEnding as Week,

Date as Date,

DOW as DOW,

num ((Max ([TotalWait]))/60, '#,##0')&':'&Mod(Max([TotalWait]),60) as SummVal,

'Max Total Wait' as SummType

resident EDDATA

group by Campus, Year, Qtr, Month, WeekEnding, Date, DOW

Re: Calculating Maximum Wait Time as HH:MM

Anonymous — Tue, 07 Jun 2016 14:04:53 GMT

Hi Claire,

Try this: