Timeline Views (TLVs) allow you to group time-based data into "buckets" of daily, weekly, or monthly granularity in the user interface.

images/download/attachments/144835627/firstTLVReportAfterExecution-version-1-modificationdate-1645046976000-api-v2.png

For example in the above screenshot, the application is displaying values for RequestQuantity in a DAILY bucketized format.

TLVs File Location and Extensions

TLVs can be defined as part of a Module, a dataset (SPT), or an EPT. You can edit your timeline view definitions in the Studio, or using any text editor.

Within a Module, a TLV should be saved as ".tlvs" file under the "tlvs" folder. (EPTs work similarly.)

images/download/attachments/144835627/tlvLocationModule-version-1-modificationdate-1645046985000-api-v2.png

In the SPT, TLVs should be saved under dataset_name/studio-src/Standard_Retail_Process_Template/__0/customAPI/tlv/TLVs.xml

images/download/attachments/144835627/tlvLocationDataset-version-1-modificationdate-1645046999000-api-v2.png

All SQLs in the subsequent chapters are dummy SQLs for illustrating simple examples. Ultimately you will use real queries to select against tables containing business transactions.