Count the total days worked per agent using pivot

Comments

4 comments

  • Avatar
    Tri Anthony Situmorang

    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
  • Avatar
    Master Yoda

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

    0
    Comment actions Permalink
  • Avatar
    Delsaran Bigglesworth (Edited )

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

    0
    Comment actions Permalink
  • Avatar
    Tri Anthony Situmorang

    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.