Active Employees per Month

Comments

2 comments

  • Avatar
    Michael Becker

    Hi Steven,

    this looks to me as data modelling thing, you need to get your data (through Transpose) to stage where table holds all possible dates and users combinations as lines (within date ranges specified). Soemthing liek that:

    user id | date

    1 | 1/1/2019

    1| 1/2/2019

    1| 1/3/2019

    and so on until you get all dates within start and end date. Then on front end you count user id, with filter setting it to last day of month. Hope that helps.

    Regards,

    Michael

    0
    Comment actions Permalink
  • Avatar
    Steven Chen

    Hi Michael,

    Thanks for your input but we're actually trying to avoid creating date records for each user since we have a few hundred thousand employees which would in turn create an exponential amount of records. 

    Thanks,
    Steven

    0
    Comment actions Permalink

Please sign in to leave a comment.