...

The tile shows the number of the crew with an unconfirmed sign-on/off. The view is based on the crew list Unconfirmed Sign On/ Off and works only if you have it in your system.

...

select 
  count (PIN) 
from VIEWID 
where Issue='Unconfirmed Sign ON' 
--and NUMORGID=:P_CLIENTID

...

Tile and Frame Setup

The tile should be setup set up in the following way, with the link to the Unconfirmed Sign On/ Off crew list view. The rest of the settings are up to your preferences.

...

The frame should be setup set up with the link to the proper data-source. The rest of the settings are up to your preferences.

...