Count the total days worked per agent using pivot

Follow

Master Yoda

December 27, 2019 13:42

I already have a pivot widget where in rows there is the name of the agent and in columns is the month in a year (Jan-Dec). I want to show in the values side the total number of worked days in each agent but I can't do it with (SUM(Count(Days in timestamp)). Is there other way to have this result?

0

• 

  Tri Anthony Situmorang December 27, 2019 14:47

  Hi,

  Perhaps what you wanna do is multi-pass aggregation. In that case, the formula should follow this pattern:

  SecondAggregation(Dimension, FirstAggregation(Measure))

   

  So in your example, it should look like this:

  SUM(Month, COUNT(Days in timestamp))

   

   

  1

  Comment actions Permalink
• 

  Master Yoda January 02, 2020 09:26

  I think this is incorrect because when I used this the days that the agent didn't worked has result.

  0

  Comment actions Permalink
• 

  Delsaran Bigglesworth January 03, 2020 16:56 (Edited January 03, 2020 16:57)

  I like this! I never thought to use the filter function like that. Thank you

  0

  Comment actions Permalink
• 

  Tri Anthony Situmorang January 08, 2020 16:39

  Hi Master Yoda,

  Shouldn't a simple COUNT(Days in timestamp) work?

  I just read your question again and looks like there isn't any need for multi-pass aggregation.

  When you add count of days as the value, each cell should show the count of days for each employee in each month.

  Let me know if I'm understanding correctly.

  0

  Comment actions Permalink

Please sign in to leave a comment.