Description

The tile shows how many changes were made in the Employee Portal to the Travel docs within today. The view is based on the crew list Changes to Travel Documents from APP and works only if you have it in your system.

Tile Preview

Data-source

The data-source should be added under the General Codes before setting up the tile. It defines the selection for the tile.

select 
  count (PIN) 
from VIEWID
 where convert (date, changed) = convert (date, GETDATE())

Tile and Frame Setup

The tile should be setup in the following way, with the link to the Changes to Travel Documents from APP crew list view. The rest of the settings are up to your preferences.

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

In our example we use:

• Tile Color: Salmon

• Font Size: 11

• Font Name: Arial

• Align: MiddleCenter