4 Replies Latest reply: May 26, 2011 4:49 AM by Byron Van Wyk RSS

    Distinct Count but Sum Total

    Byron Van Wyk

      Hi All,

       

      I was busy creating a test QV document to load as I couldnt find a way to get to the answer I was looking for. When creating the document I managed to figure a way out but it looks messy and Im wondering if there is a better way to do this.

       

      I have attached the QVD with an inline list of what my data looks like.

       

       

      The Question:

      ----------------------------------

      Agents are logged onto multiple skillsets simulataneously, the logged on time for each skill set would be the same because of this. I want to know what the accumulated logged on time is for an interval of time for all agents logged in. Taking into account that I need the (MAX) logged on time for each agent, not the combined for each agent for each interval.

       

       

      Cheers,

      Byron