Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

KPI Widget - Average on minimums

Hi Guys,

I have been searching forever for a easy answer to this problem that i have - please can someone help

Data example

Capturer     start time     date

Martin          07:00          13/04/2016

Martin          08:00          13/04/2016

Alex            06:00          13/04/2016

Alex          12:00              13/04/2016


And so on....


I need to use a KPI widget to display the average of the min start time, IE; Martins min start time(which is 7:00) and alex min start time (which is 6:00) thus the average would be 6:30 (which the KPI widget should display) sounds very simple but i can not get it at all to calculate the avg of the min start times, it always just displays the lowest value in the start time range and not an average.


Any idea?


Thank you,

2 Replies
sunny_talwar

May be this:

Time(Avg(Aggr(Min([start time], Capturer)), 'hh:mm')

MK_QSL
MVP
MVP

=Time(Avg(Aggr(Min(Time#([start time],'hh:mm')),Capturer)),'hh:mm')