Forum Discussion
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 can I add an extra request to the solution above. The result now is a list that calculates what I need per dept / employee / date.
But suppose I want a more general clustered or stacked bar chart that shows per dept the total number of absence streaks that lasted less than 3 days and the total number of absence streaks that lasted 3 days or more.
I noticed changing this context had some strange effects on your calculations.