1 Reply Latest reply: Mar 9, 2012 8:38 AM by Andrew Cowell RSS

    Class Expression as Dimension

    Byron Van Wyk

      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