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

Average Per Day

Hi Guys,

I need an expression to populate a field in a Straight Table.

The Dashboard is for reporting call volumes in a call centre. I inport the following fields:

SpecialistID (the first name of the person who took the call)

LoggedDate (the date the call came in)

I currently have a master calendar setup with the following fields:

Day

Month

Year

Quarter

I need to populate a table with the Average number of calls per day based on the current selection in the master calendar.

eg:

SpecialistID     Avg calls per day

JOHN                       10

JACK                        12

This must be reflective of the current date range selected (so if January is selected, it will calculate average number of calls for each Specialist in January.

Any help would be greatly appreciated.

Regards

L

1 Solution

Accepted Solutions
jagan
Luminary Alumni
Luminary Alumni

Hi,

Try like this

Use SpecialistID  as dimension and use the following expression

=Count(SpecialistID) / Count(Distinct LoggedDate)

Hope this helps you.

Regards,

Jagan.

View solution in original post

5 Replies
IAMDV
Luminary Alumni
Luminary Alumni

Hi L,

Have you tried using Avg(SpecialistID) as expression and SpecialistID as Dimension on a straight table. If you the LoggedDate is linked to the Calendar Table then you will see the results based on the user selections i.e. Day, Month, Quarter & Year. QlikView selections will automatically render the calculation and you don't have to do anything unlike traditional BI Systems.

Does this makes sense?

Cheers,

DV

www.QlikShare.com

Not applicable
Author

Hi Deepak,

This is what I originally thought but this would not calculate Average Calls Per Day.

I need it to count the number of times the Secialist's name shows up between the date ranges, then devide that by the number of days between the selection to get the Average per day.

Regards

IAMDV
Luminary Alumni
Luminary Alumni

NP. Do you mind posting some sample data? I can create a demo app and it's easier to work with your sample data. Possible?

Thanks,

DV

www.QlikShare.com

jagan
Luminary Alumni
Luminary Alumni

Hi,

Try like this

Use SpecialistID  as dimension and use the following expression

=Count(SpecialistID) / Count(Distinct LoggedDate)

Hope this helps you.

Regards,

Jagan.

Not applicable
Author

Thanks Jagan,

This looks like it is working perfectly,

I forgot about using DISTINCT

Many thanks!

Also thanks to Deepak for starting the ball rolling!