Forum Discussion

RudyL's avatar
RudyL
Helper I
2 years ago
Solved

Absence streak

Hi, The request may look familiar but I can't figure it out with the examples in the community. So I put in a new one.  I have a table like the one below (first five columns). All employees are cro...
  • tamerj1's avatar
    tamerj1
    2 years ago

    Hi RudyL 
    You are right the ABSSTREAK calculated column. However I could not generate the other problem. Looks like the engine treats the blank as a zero anyway. I have a added a COALESCE statement as an additional layer to confirm the result.

     

RudyL's avatar
RudyL
Helper I
1 year ago

Hi tamerj1,

your last update with the coalesce did the trick. Forget about my third remark. I thought that absences that started on the first date of the data set were not correctly handled, but they are. It turns out I used filters per year and had to add the absence year as an extra partition to make it work. That would split absence streaks from one year to the other as two seperate ones. 

So thanks again !!!