Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Calculating day average based on hourly numbers calculation?

SS.PNG

Hi guys,

As above, I have the first 5 columns. The 6th column is how I calculate hourly efficiency.

How can I calculate average hourly efficiency for that day without having to calculate the column 'Hourly Efficiency' and then take an average of it? I am trying to do that in a KPI text box only for the average hourly efficiency for that day.

Thank you.

2 Replies
Highlighted
Specialist III
Specialist III

Hi, for get KPI in a text box try with :

avg(aggr( (Count of case#) / ((Head Count)*(Hourly Target Count of Case#)), Date YYYYMMDD))

Highlighted
Creator II
Creator II

Thank you Jean. The only correction needed was to replace Date YYYYMMDD with Time HH to take an average after calculating hourly.