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.

     

tamerj1's avatar
tamerj1
Community Champion
2 years ago

Hi RudyL 

Looks like somehow I missed your reply. 
ABSENDDATE and ABSDAYS are measures. That means in the table visual the EMPID is already available in the fillter context as part of the visual. 

RudyL's avatar
RudyL
Helper I
2 years ago

Hi tamerj1 , please see my example data that i gave in reply to another contributor. With this sample data your solution doesn't seem to work.

  • tamerj1's avatar
    tamerj1
    Community Champion
    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.