TS. Pivot Tables

You may create Pivot table type report by choosing this option from Add Report dropdown.

Schedule > Reporting > Add Report > "Pivot Report"

Overview

Pivot table comes in really handy as a quick way to make an interactive summary from many records. Among other things, it can automatically sort and filter different subsets of data, count totals or calculate average. Another benefit of using pivot tables is that you can set up and change the structure of your summary table simply by dragging and dropping the source table's columns.

In the top right part of application you see the list of all project elements to work with, organised by levels or folders.

Drag and drop parameters to display in your custom report to related fields from the top right part of the Reporting tab to the bottom one. They will be automatically displayed in the main viewport accordingly.

You may also customise right part form layout by pressing top right icon and selecting desired layout of areas and fields as shown below.

Customization form layout

By default “Field Section and Areas Section Stacked” layout is set. You may change it at any time to suit your display preferences.

In a bottom part of this right section you see four areas where you can drag and drop required fields, it has an automated sorting function preventing you from dropping wrong fields into wrong areas. To remove a field from an area simply drag it out and drop in any spot where it is marked by the Black Cross sign.

Deleting field from area

You can always manually change the layout of your pivot table by dragging fields to the desired locations between existing columns.

Press the filter icon to open its dropdown and select options to display and organise them in your table.

Filter options dropdown

Press Configure Format button to open Configure Pivot Grid Appearance window where you may add more custom settings, such as text font, size, style, colors and format for each element of a table.

Configure Pivot Grid Appearance window

Listed in this section are a number of common pivot tables for error-checking your project setup. 

Destination Check

Create a pivot table to validate the destination logic setup: 

1. Go to Schedule tab > Reporting tab >  "Add Pivot Report". 
2. Click in the name field and rename to "Destination Check".
3. Drag "Activity Type" into the Filter Area and set the filter to show "Mining only". 
4. Drag "Mining_wetTonnes" into the Data Area.
5. Drag "Destination.Top" into the "Columns Area".
6. Drag "Source Parcel" into the Row Area.
7. Drag "Destination Logic Rule" into the Row Area.

Use this table to identify if any Destination Rules are sending material to the wrong location.

For added detail, try dragging Source.Mine/Pit/Stage into the Row Area

Step Logic Check

Create a pivot table to validate the step logic setup:

1. Go to Schedule tab > Reporting tab >  "Add Pivot Report". 
2. Click in the name field and rename to "Step Logic Check".
3. Drag "Activity Type" into the Filter Area and set the filter to show "Mining only". 
4. Drag "Mining_wetTonnes" into the Data Area.
5. Drag "Fleet" into the Column Area.
6. Drag into the Row Area:
   1. "Source.OpenPit",
   2. "Destination.Top",
   3. "Step Logic Rule".

For added detail, try adding Source Type and Destination Type to see the individual step logic components

Use this table to identify if any Step Rules are using fleets in the wrong areas.

Bench Progression

Create a pivot table to visualise the bench progression by pit and stage:

1. Go to Schedule tab > Reporting tab >  Add Pivot Report. 
2. Click in the name field and rename to "Bench Progression".
3. Drag "Source.OpenPit" into the Filter Area and set the filter to show "OpenPit only". 
4. Drag "Mining_wetTonnes" into the Data Area.
5. Drag "Period" into the Column Area.
6. Drag into the Row Area: Source.Mine/Pit/Stage/Bench.

Bench progression pivot table

Use this table to confirm that bench turnover is within practical limits per period.

Loader Rate Check

Create a pivot table to validate the production rates being used by the excavation equipment:

1. Go to Schedule tab > Reporting tab >  "Add Pivot Report". 
2. Click in the name field and rename to "Loader Rate Check".
3. Drag "Activity Type" into the Filter Area and set the filter to show "Mining only". 
4. Drag "Loader" into the Row Area.
5. Drag "MutexParcel.Haulage" into the Row Area.
6. Drag "HaulageResult.LoaderProductionRate.WTPH" into the Data Area.

For projects using Loaders as Agents, drag Agent Rate field into the Data Area for direct comparison

Use this table to confirm the loader rates match with planning parameters.

Cycle Time Check

Create a pivot table to validate the average cycle times being used by trucks.

1. Go to Schedule tab > Reporting tab >  "Add Pivot Report". 
2. Click in the name field and rename to "Cycle Time Check".
3. Drag "Activity Type" into the Filter Area and set the filter to show "Mining only". 
4. Drag "Truck" into the Row Area.
5. Drag "Source.Mine/Pit/Stage" into the Row Area.
6. Drag "Destination.Name" into the Column Area.
7. Drag "HaulageResult.Times.Total" into the Data Area.

Average cycle time pivot table

Use this table to confirm the average cycle times match with historical numbers.

Press the Copy Image button to make a screenshot of your table, which will be copied to the clipboard and can be pasted directly to your reports or presentation.