Substitute agg() in the load script

Applicable88 — Wed, 20 Jan 2021 09:52:58 GMT

Hello,

I want to load a start time and a end time as a duration already in the load script. It's a mess when it needs to be calculated later on, because the functions getting very long, instead just using the duration as a plain time or number to calculate.

Due to many factors I have to aggr the time to many fields to filter the correct time.

Right now i'm using something like this:

hour(sum((aggr(Max(QueueFinishedTime),QueueIdentification,State,ActionName))-(aggr(Min(QueueStartedTime),QueueIdentification,State,ActionName))))

How to write this kind of calculation into the loading script?

I hope someone has an idea. Thank you very much.

Best.

Re: Substitute agg() in the load script

PriyankaShivhare — Fri, 22 Jan 2021 02:31:50 GMT

Hope this Helps

Duration:
Load *,
maxTime - minTime as Duration;
Load Max(QueueFinishedTime) as maxTime ,
Min(QueueStartedTime) as minTime,
QueueIdentification,
State,
ActionName
Resident Source
group by QueueIdentification,State,ActionName

in the Front End Expression : hour(sum(Duration))

Thanks,
Priyanka

topic Re: Substitute agg() in the load script in App Development

Substitute agg() in the load script

Re: Substitute agg() in the load script