Forum Discussion

aid928's avatar
aid928
Icon for Helper I rankHelper I
3 years ago
Solved

Managing absences per month

Hi folks,   Trying to put together an absence management dashboard.   Some sample data of one of my tables is:   Staff Name Start Date End Date Absence Category Duration Aaron Anderso...
Need Help
  • aid928's avatar
    aid928
    Icon for Helper I rankHelper I
    3 years ago

    Absolute life saver, thanks so much for your help!

  • aid928's avatar
    aid928
    Icon for Helper I rankHelper I
    3 years ago

    Hi Ahmedx,

     

    Thanks again for this solution. I do however have a small follow up question if you'd be able to help. 

     

    So your solution absolutely helps identify days off per month for this employee. However, say rather than a full days absence, they record half a day - so their absence on 26th August, say it was for 0.5 days rather than a full day. Is there anyway the "days was off for this month" measure could be amended to reflect half or part days?

     

    Thanks again.

     

    Aidan

    • Ahmedx's avatar
      Ahmedx
      Icon for Super User rankSuper User
      3 years ago

      how did you mark these half a day in the table? Show me please

      • aid928's avatar
        aid928
        Icon for Helper I rankHelper I
        3 years ago

        Aplogies I never did, but if you take for example row 4 in the table, say the Duration value was equal to 0.5 instead of 1 - how could we then implement that into the "days was off for this month" measure?

  • aid928's avatar
    aid928
    Icon for Helper I rankHelper I
    3 years ago

    Sorry Ahmedx, last question.

     

    If I wanted to calculate the total absences of the team per month, rather than splitting by employee, how could I make a measure for that?

     

    Thanks,

     

    Aidan

    • Ahmedx's avatar
      Ahmedx
      Icon for Super User rankSuper User
      3 years ago

      probably so

      • aid928's avatar
        aid928
        Icon for Helper I rankHelper I
        3 years ago

        Hi Ahmedx,

         

        I had actually tried this, but unfortunately the figure it produces isn't correct. It works when filtering per a single employee, but when no filter is applied the total isn't correct.