TS Chrono Reports

Owned by iarmstrong
Last updated: Jan 02, 2024 by Todd Eggerman
7 min read

Chrono reports are the static reports with the date in columns and the data in rows. These reports are used to create static report tables to match business standard templates. 

The Chrono Reports workspace consist of four main tabs with different functionality, the toolbar, and Errors List. Detailed description of these reporting components see below.

Sample Chrono Summary report

Add New Chrono

To create this type of report select "Chrono Report" from Add Report button dropdown.

Schedule > Reporting > Add Report > “Chrono Report“

A New Chrono report will appear in the list of reports. Left click on it and rename as desired.

By default, an empty report will be displayed with the Table Setup and Charts Setup tabs available. Populating data into them correctly will unlock the Table and Charts tabs.

Table Setup tab

This section details how to make a simple schedule summary sheet. 

  1. Go to Schedule tab > Reporting tab > Add Report button > "Chrono Report".

  2. Click in the name field and rename to "Summary".

  3. Open the Table Setup tab to edit the report.

  • Report rows can be added, removed, indented, moved up/down, copied, cut, pasted using the top toolbar. 

  • When creating repetitive reports (ie. Pit1, Pit2, Pit3, ...), start by creating a table template. Once complete, highlight the rows and select the Copy icon. Paste the copied rows and use the Find and Replace function to update the references. 

  • Use Change Time Settings button to set reporting intervals and start/end periods. You may choose to report by "Scheduling Periods", "Number and Name", "Calendar Years", "Financial Years", "Calendar Quarters" etc. For the Start and End periods you may select certain periods dates or schedule start/end to display in your report.

Set the values in each column to match your data set. Description of the columns see in the table below.

Column

Function

Column

Function

Type

Set row type to “Title”, “Row” or “Iter”.

  • Title fields act like folders. Their only function is to contain child rows.

  • Row fields look up a value from some data source.

  • Iter(ative) fields can be used to loop over a list of items, and return the value for each item.

Name

An alphanumeric identifier used to create a unique lookup for the row, which can later be referenced in graph series and calculated fields. It is also used as a lookup code for formulas and charts.

Caption

The display name of the row in the output table.

Indent

Creates nested table fields. Indentation of child rows under title rows.

Hide

Optionally hide a field from the output table.

Units

Optionally specify units (meters, bcm, tonnes).

Format

Excel-style number formatting.

Initial

Optionally set the opening value for cumulative sums of this field.

Data Source

Choose a data source from a list or create a calculated field.

Item

Choose a field from the data source or enter a calculation

Filter 1 Field

Filter field for filtering results.

Filter 1 Value

Filter value to apply to the filter field.

 

  • Red circle on the left of the Type column indicates that you have made some mistakes filling up a table or there are some unresolved issues. Check the Error List below to get a description and fix all the errors listed.

Other toolbar buttons:

Button

Icon

Description

Button

Icon

Description

Find and Replace

<CTRL>+ H. Use this icon to quickly update a range of selected cells when editing or updating reports

Convert to Static Report

Convert your report to static. Note that if your report currently has errors, they must be resolved before the report can be converted to a static one. See the Errors list below.

Manage Custom Lists

Opens Custom Lists dialog where you may configure custom lists grouping different items into custom categories. Custom lists allow selection of different fields and you can also access them in the calculated fields.

Formatting

Use this button to:

  • configure Pivot Grid Appearance (font, size, style, color, background color for captions and samples),

  • clear formats,

  • paste or copy formats,

  • perform period formatting (font, size, style, color, background color for period captions and period names),

Usage Hints

Applicable hotkeys you may use when working with a report.

Table tab

Once you resolve all the issues listed in the Error List the Table tab becomes available. Open it to see the final report. 

Right click on any field header to set or reset a color

Right click on any field row to copy its full name

Charts Setup tab

Before setting up tables:

  1. Select the Charts Setup tab.

  2. Add a new chart.

  3. Rename the chart to "Stockpiles".

  4. In the Primary Axis panel,

    1. change the caption to "Tonnes",

    2. change the Format to "0.0%".

  5. In the Series panel,

    1. Add three series.

    2. Name the series ROM HG, ROM MG, LG.

    3. Set the fields to "inv.hg", "inv.mh" and "inv.lg".

    4. Select from the Series Type column "FullStackedBar". You may select different types for each series to display in the Charts tab.

    5. Select colours for each bar.

Charts tab

Review all data you populated in the previous tab by opening the Charts tab.

Note, that this tab is only available if no errors remaining in the Chart Setup tab.

You may always come back to the Charts Setup tab to change Series Type to display in charts.

Setup tips

Filter Wildcards

The following wildcards can be used to filter the data:

Available filters

Available filters

hg

Returns "hg"

hg?

Returns "hg" plus exactly one trailing character, ie. hg1, hg2, hg3

*note "hg" would be excluded in this filter, because it only has two characters

hg*

Returns "hg" plus any number of trailing characters, ie. hg, hg1, hga, hg171101

hg|bg

Returns "hg" and "bg" 

!hg|!bg

Returns all parcels excepting "hg" and "bg"

Calculated Fields

Calculated fields use a formula to reference the Name field of other rows. In addition to the formulas below, Excel-style addition and multiplication may be used. 

Available formulas

Available formulas

V("prod.wt.ore")

Returns the value of "prod.wt.ore" in the current period

CV("prod.wt.waste")

Returns the cumulative values of "prod.wt.waste" up to and including the current period

S("prod.wt.*")

Sums all child fields of "prod.wt" in the current period (using asterisk as a wildcard for all children)

SD(V("value1"),V("value2"))

Safe Divide value1 by value2. If value 2 is zero, the result is zero

Math.Round(SD(V("value1"),V("value2")))

Safe Divide result is rounded to the nearest even integer

Math.Ceiling(SD(V("value1"),V("value2")))

Safe Divide result is rounded up to the ceiling

Math.Floor(SD(V("value1"),V("value2")))

Safe Divide result is rounded down to the floor

V("myValue") > 0 ? 1 : 0

If "myValue" is greater than zero, return one, otherwise return zero

 

If the formula has been incorrect previously, and you make a change to correct it, it won't turn black straight away. Switching to the Chart Setup tab and then switching back will resolve this.