Discussion Board for collaboration related to Creating Analytics for QlikView.
I have incident data stored like the below and I need to calculate the average number of tickets created by hour each day. I know I need to use AGGR() but I just can't quite get it right.
In the end I want to see:
You can use:
avg(aggr(Count(distinct Ticket), Hour, Date))
So I didn't even think to just throw Date, Hour together into the Aggr() function. You both responded almost identically but Maxgro listed Hour first. Does order matter?
In some circumstances it might matter (unless you have QV12, where we have work around available), but for this particular scenario it won't.