Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I have quite a bit sample Im working with, 500K rows by 40 columns. Each person on the list is performance measured by 30 minute interval. So one person would appear throughout the day by each 30 minute increment. I want to use the class QV function to build a histogram.
The problem is, I dont want it to count by 30 minute interval but rather by day.
So instead of
DIMENSION: Class(CallsHandled,5)
EXPRESSION: Count(DISTINCT People)
I want
DIMENSION: Class(Date(CallsHandled),5)
EXPRESSION: Count(DISTINCT People)
I know by dimension above makes no sense, but i guess you guys understand what I am doing with it. Please let me know if this is at all possible
Cheers,
Byron
For anyone coming across this post in their search for an answer to a similar challenge, I thought I'd signpost the following thread that may be of help:
http://community.qlik.com/message/30237#30237... (Bryon, I can only assume that you found a solution to the question you posted above and, if so, would encourage you to share it here for the benefit of anyone searching the forum - Cheers)