Observe the TimeLineDD Required File Prompts

 

TLDDRscPrompts TLDDataToMeas

 

The Resource File can be Employees, Work Stations, Inventory Items, etc.  Anything with an unique Id that has something to measure/count/Average/sum, etc.  It only Needs a Key on the Unique Id and a Field(s) with the information to display in the Row(Header)  in the Left Column of the Listbox. Embeds are provided to use a local variable for Resource Display and build it as needed or for additional filtering of Resources to exclude.

 

Resource File

ResourceName    Key(for Display) -- Can be Id

ResourceId Field  --  (Unique)To Tie to Data File to Measure

ResourceName  Field(s)  ---   Displays in column or row Headers for the Resource.(Can be Expression)

 

The Data File to Measure Only needs a Date Key and Field to access.  It needs a Field storing the RscId that is being Measured, and a Field to Measure.(invoice total, Qty Sold, Minutes in Appointment, etc.)  The field to measure must be a numerical(decimal,short,Long,Real, etc)

 

Date keys used in the Template need to be in ascending order or the template will not work with the file.

 

Data File to Measure

ByDate    Key

Date Field

ResourceId Field  -- to match Resource File

Measure Field(numerical)