Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
jphillipsepg
Contributor
Contributor

Top 10 Accounts by Hour of Day

I am trying to present in a Stacked Bar chart the Top 10 Accounts by Hour of the day.  Specifically, I want to see the Top 10 Client within each our of the day based upon their  number of Calls for that hour.

I have the graph presenting the hours, and showing the accounts but it seems as though I am only getting the Top 10 for the day, and then showing each of their call volumes for each hour of the day.. which is NOT what I am looking for.  I want to see Account 100 if they had the most calls in the 4pm hour even if they were not in the top 10 for the day.  Additionally, I am only seeing 1 account for the first hours of the day..  

Here is the formula I have in the Accounts Bar and I am NOT including nulls

//------------------------------------------------

If(Aggr(Rank(Count(Distinct(UCN))),Account)>=10,Account)

//----------------------------------------------

The measures is 

Count({<[Call Type]={'Live'}, Answered={">=1"}>}Distinct(UCN))


What am I missing.. and THANK YOU in advance

1 Reply
Anil_Babu_Samineni

Try this as measure?

Count(TOTAL <Date> {<[Call Type]={'Live'}, Answered={">=1"}, Time={'4 PM'}>}Distinct(UCN))

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)