Users that have not submitted a Time Card

[hurbanus]

Hi 

I am trying to create a visualization for a dashboard that shows out of the 202 users with the timecard_user role for  Last Week  and This Month the number of user with no time cards.

I have tried a database view and that is not working. 

I am considering a Formula Indicator using the an indication for "Number of Users with timecard_user role" from the sys_user table and subtracting "Number or users with time card"  from the time_card table.

If you have tried this did it work for you?  How were you able to determine the number of users without time cards?

[Kieran Anson]

Hey,

Not sure if this will help. But there is a time sheet exceptions table which you might want to report on instead? It's updated daily to reflect the state of a users time sheet. 'time_sheet_exception' is the table name, and has a state column for visibility of overall timecard progression