Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

Users that have not submitted a Time Card

hurbanus
Tera Contributor

‎03-11-2026 04:13 PM

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?

0 Helpfuls
  • 404 Views
1 REPLY 1

Kieran Anson
Kilo Patron

‎03-12-2026 11:28 AM

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 

0 Helpfuls