Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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,

Tags (1)
2 Replies

Re: KPI Widget - Average on minimums

May be this:

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

Re: KPI Widget - Average on minimums

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

Community Browser