Get a first look at what's coming. The Developer Passport Australia Release Preview kicks off March 12. Dive in! 

Users that have not submitted a Time Card

hurbanus
Tera Contributor

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 REPLIES 0