A custom extract label allows a central report on a dashboard to use a dynamically changing label. This is displayed on a Central report as the Extract Date.
There are 3 options available:
When a central report runs the extract date is determined by the Pathway Schedule. Reports that run, by default will display the Report date that has been configured to run
You can type free text into the custom extract label. Note: the free text will be replicated for every extract.
Using a combination of free text and simple code, you can configure the extract label to dynamically change every time a schedule runs. This negates the need to manually change the label prior to each schedule running.
The dynamic syntax is %d, DD Mon YYYY, M, 0
Extract for %d - The label containing the date place holder (%d).
DD Mon YYYY - The date format.
M - The date unit MONTH.
0 - The number of months to add\subtract to the report date that is being displayed
The 0 syntax allows you to move the display day\ month\ year forwards or backwards if required. Extracts on the 1st of the month are usually for the previous months activity. This can be displayed in the custom extract label.
Example 1
Extract label on the Central report screen displayed as "Monthly Extract for 01st January 2020" (Ran on the 1st of February)
Configured as:
Monthly Extract for %d, DD Mon YYYY ,M, -1
Free text can be positioned before or after the %d but within the syntax.
Example 2
Extract
label on the Central report screen displayed as "Extract run
on - 01st February 2016 for
last calendar month" (Ran on the
1st of February)
Configured as:
Extract run on - %d for last calendar month, DD mon YYYY, M, 0