Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
i have a chart in Hour, Day, Month, Year Trend for total logged Calls. can i show the agent name instead of the value who have logged more calls as per the dimension.
Please find the attached image for reference.
Regards,
Grace
Please try attached document.
You should also aggregate the count over the Assignee and Call date.
Hope the attached document helps.
Regards,
SK
Hi Grace
Can you please attach sample data file
Regards
Kushal Thakral
Yes you can.
Try using the dual function in the Expression that calculates the total logged calls. Prior to that you will have to build an expression which returns the name of the agent with the max calls by hour.
So your expression should look something like -
Dual(Agent_expression, Current_Expression).
Hi Grace
This is what you wanted in qlikview
see for 1/1/2014 Madhura is topper and 2/1/2014 someother person... so i want the count and name of the topper person in chart...
how do i do this... plz help me
Hi,
Add one more expression
=FirstSortedValue(Assignee, -Calls)
and Unselect Line in Expression tab and Select Values on Data Points option
Regards,
Jagan.
FirstSortedValue(Assignee,count(DISTINCT {$<Link_Flag={'Arrival'}>} TicketID))
its giving null values...
Please try attached document.
You should also aggregate the count over the Assignee and Call date.
Hope the attached document helps.
Regards,
SK
Hi,
FirstSortedValue(Assignee,-Aggr(Count({$<Link_Flag={'Arrival'}>} DISTINCT Call_Id),Assignee,Call_date))
Regards,
jagan.