The MP-Web Table Builder
Introduction
The Table Builder allows users to create tabular output for data analysis, onward reporting, and Excel export. It replaces the simple List and Grid tables from older versions of MonitorPro. Users can select the fields they want within the table based on several base-type formats. They can also merge and filter data by adding or excluding additional fields such as Data Source, Sample Type, and Time.
Example Summary and Statistics Table
Example Grid Summary Table
Base Types
To create a table, users can select the Base Type that most closely represents their desired output.
Base List Table
The List Table is the most straightforward layout, with a single row for the data value. It allows additional metadata columns, as each row has a unique value.
The List Base Type also allows the highlighting of Compliance breaches.
It contains the following standard columns. Unlike some of the Base Types below, removing columns will not aggregate or summarise data in a List. Each record will remain unique, but context might be lacking where columns are removed (e.g. where data is distinct by Data Source, but Data Source is excluded).
Base List Summary and Statistics Table
This Base Type provides a summary of the data in the Dataset. Various statistics can be added and removed to build a suitable output.
Base Grid (Variable) Table
The simplest of the Grid by Variable layouts gives a tabulated view of the data. This format is standard for onward reporting and data use.
It includes the following columns.
Base Grid (Variable) Extended Table
The extended version of the Grid by Variable allows for including a wide range of metadata for Objects, including Sample Points. Otherwise, it is identical to the Base Grid.
Base Grid (Variable) Summary Table
This option allows for a typical Variable Grid but with the ability to summarise the data, excluding the need to create calculations to output summarised data. The inclusion or exclusion of specific fields will dictate the level of summarisation. Users can then choose the function (min, max, average, percentile, etc.). By default, the data will be summarised using the Sample Point.
This example uses the Sum and Month functions:
And using the Sum and Year functions:
Removing the Sample Point from the table moves the summarisation to the Data Type (Site) level. In this example, the total for all the dust gauges is given.
There are options to include the end date and start date of the summary period, which can be helpful, particularly where the data is to be exported to Excel for trending or further analysis.
Base Grid (Variable) Compliance Table
This output natively displays applicable compliance breaches and highlights them by Compliance Importance (High Priority Breach, Breach, Warning, Internal). An additional compliance type, called multiple records with breaches, can be displayed. This signifies that the value in a particular cell contains more than a single data point and is also breaching compliance. Please take a look at the section below on Multiple Records for more context and guidance on refining the Dataset or Table to remove these records.
The base layout is a Variable Grid.
The Compliance Table includes the following standard fields.
Base Grid (Sample Point) Table
Similar to a Variable Grid, but pivoted, this layout allows data to be displayed with Sample Points as the primary columns in the grid-based table.
The default columns are detailed below. These can be excluded if applicable. In the example above, the Dataset has been refined to include a single Variable, Source, etc., and so those fields can be removed to offer a simpler layout. Care should be taken, however, not to remove fields that would otherwise lead to the merging of data.
Use
To produce a table, select the desired option from the drop-down menu, and the table will be created based on the data contained within that Dataset. There will be several groupings:
My Tables are table layouts that your user has created and saved. They are not accessible or viable to other users.
Common Tables are table layouts that a user has created and saved to share with others. These would be typical reporting or company layouts for sharing data in set formats. When the layout is saved, tick 'Include in Common group' to include it under the Common Tables heading.
Base Tables are the common Base Types that can be used and modified for a single purpose, but cannot be saved; they can only be saved as one of the two types above.
Tip
When saving a new layout, please ensure the title is as descriptive as possible to make it easy to reuse later.
Columns
Each Base Type will include a number and type of Columns applicable as a default. To remove columns that are not desired, the user can click on the three-line icon next to the Table name and then click the x on the applicable column to remove it.
In the Summary Base Types, columns will be removed to summarise data as desired based on the Summary Type function (min, max, avg, etc.). For example, creating an annual total for a particular group of Sample Points may be desirable. In this example, a yearly period is used. 
Columns can still be excluded for non-summary Base Types to offer your desired output. However, care should be taken to avoid merging data unintentionally by removing columns that make the data unique. More details on this are in the Multiple Records section below.
Ordering
Hover your mouse over the three-line (hamburger) icon to order the table's columns. Then click and drag to the order where you want that column to appear. The column order dictates the row order by default. Changing the first Column to 'Date' would order the data displayed by Date in descending order, and then by Sample Point. To override this (for example, to have the Sample Point in the first Column but order by Date), select the Primary order and select the descending (down arrow) or ascending (up arrow).
Note
Variable ordering in Grid layouts will be based on the Dataset order. To manage this, edit the Dataset and order the Variables as required. The table will then respect this order.
In the standard Grid Base Types, Variables with no data are suppressed by default. To include the Variable name as a column header but display blank rows (or to assess where data is missing), uncheck the box in the settings for that table.
Multiple Records
All grid layouts can merge data based on which columns are included or excluded from the table. Generally, these layouts are not anticipated to merge data intentionally, and either a summary Base Type should be used or the fields that make the data unique should be included. The cell will be highlighted in Grey to emphasise that data is being merged. For example, there are two samples for the same Sample Point, Variable, Data Source, Date/Time and Sample Type. The only field that denotes the data as unique is the Sample Reference, which must be included to ensure that each row of data is unique. If the intent is to summarise this data, select one of the summary base types, which gives the option of what operator to use to summarise.
Export
You can export all user-generated tables to CSV or Excel format. Excel exports will honour the compliance and multiple record colour-coding.
