Forum Discussion

IPGeorgiev's avatar
IPGeorgiev
Icon for Helper III rankHelper III
5 years ago
Solved

Count consecutive days on a specific status

Hi All,   I want to count the number of consecutive days for each attendance status for a specific employee. So here an example of the data:   Emp Id Emp Name Project Id Program Date Sche...
Need Help
Tips and Tricks
  • IPGeorgiev's avatar
    IPGeorgiev
    Icon for Helper III rankHelper III
    5 years ago

    Worked perfectly!! Many thanks!

     

    Just 1 question - what is the use of the index column in the Schedule Status table?

    • Jihwan_Kim's avatar
      Jihwan_Kim
      Icon for Super User rankSuper User
      5 years ago

      Thank you for your feedback.

      The column - Work/Off/Unscheduled column - is sorted by Index column.

      It does not have a problem with not having the index column. But the visualization would be shown like below.

      Off / Unscheduled / Work ( alphabetical order)