Data #9: Table Plots

Click to Print


Table plots allow for coloured, 3D visualisation of Table Data such as strip ratio plots.

Plotting Polygons vs. Regular Solids

Spry allows for the creation of what are called Plotting Polygons, designed specifically for use in Table Plots. Why not just use your regular solids? The reason is that Table Plots use grouping (such as grouping Strip and Block together to form a vertical stack) and only the first solid from a group is used. See the example below and the Practical Section for how to use the Generate Plotting Polygons tool.




To create a new Table Plot, right-click a Table and select Setup Table Plots.

Grouping Expression: Similar to Grouping Expressions used in Sequence Dependencies and Proximity Constraints. Must evaluate to a text result. For most Table Plots this should represent the XY coordinate Levels such as Strip, Easting & Stage. Example: Text(Strip) + “\\” + Text(Block)

Value Expression: Must evaluate to a numeric result. NodesMax, NodesMin, NodesSum and NodesWeightAvg are new Functions that refer to the groups set in the Grouping Expression. Example: NodesWeightAvg(GetValue(CoalAsh),GetValue(CoalTonnes))

Formatting Expression: Must evaluate to a text result. Example: Text(Value, “#,##0.00%”)

The Table Plot Colour Wizard data9tableplot allows you to automatically create colour ranges for your Table Plot. If no colours are chosen the resulting Table Plot will be white.

Generate a Table Plot by clicking Generate Layer which will create a Layer the same name as your Table Plot


Note that the Solid that is used in a Group is the first Index. If you need to create specific solids for Plots you can do this using the Generate Plotting Polygons tool in Spry.

Generate Plotting Polygons

Before running this tool, ensure you have a new Solids Field to hold the generate Polygons.

Right-click the Table Plots icon and select Generate Plotting Polygons.


The general rule of thumb in using the Generate Plotting Polygons tool is that you use the same Grouping Expression that you use in your Table Plot. The Polygon Z Level will differ based on the requirements you have (commonly Maximum Z or 0.0 with an Offset).


Period Progress Plots

In combination with Post Schedule Tasks (see documentation here) you can use information from your previous Schedule runs to create Table Plots that show you where you have worked by date.

The recommended steps to create a Period Progress Plot are as follows:

  1. Create a Date/Time Type Field in your Setup->Fields (inside a Post Schedule Task folder to ensure that it isn’t overwriting anything important)
  2. Create a Post Schedule Task that writes Schedule Results back to the Source Node. Generally use either ScheduleMin or ScheduleMax any other filters you might require
  3. Create a Table Plot that references the new Post Schedule Task Field you are writing to, as a starting point your Value Expression may look like: Year(NodesMin(GetValue(PostScheduleTasksDateStarted)))
  4. (Optional) Create a Post Schedule Task AFTER the Source Node one that recreates the Table Plot on each Schedule Run