The Charting Tool allows you to view the result set from a scenario run in different formats. It is available from a number of places within Source, including from the list of result sets in the Recording Manager and from within any feature editors that can load time series. Figure 175 shows the main features of the Charting Tool. The Graph tab provides a graphical representation of data, which can be customised using the Graph tab toolbar. The Table tab displays the results in a table, and the Statistics tab shows a summary of the data.

Graph tab

The Graph tab provides a graphical representation of your data and allows you to change the appearance of charts. In addition to displaying a single result set and derived views such as exceedance curves, you can combine two or more result sets. Once a charting tool contains two or more graphs, additional capabilities become available such as difference graphs and scatter plots.

Although the Graph tab allows you to combine results sets, actions taken in the Graph tab also affect both the Table and Statistics tabs.

Graph viewing options

You can control the behaviour of graphs using the Graph tab toolbar (Figure 176). The functions of each of the buttons and pop-up menus on this toolbar allow you to change how charts are displayed. These are explained in further detail next.

Combining graphs

Draggable allows you to overlay one chart onto another. There is no limit to the number of charts that can be overlaid. Each chart is assigned a distinct colour and is represented in the legend. Figure 177 contains an example of two overlaid charts. Note that when combining graphs, the units stay the same on the target chart.

To overlay charts in the Charting Tool:

• Open at least two charts and decide which one will be the target (the chart onto which other charts will be overlaid).
• For each source chart, click Draggable, then click-and-hold the mouse pointer on the content area of the chart; drag the mouse pointer to the target chart and release the mouse button.

If required, the target chart will re-scale to accept incoming data.

Multiple charts can also be assembled directly from the Recording Manager:

• Select one of the result sets that you wish to combine by clicking anywhere on its row except the Values column.
• Hold down the Ctrl key, then click any additional rows using the same method.
• Right-click on any one of the selected rows and choose View Selected from the contextual menu.

You can save the time series data by right clicking, then choosing Save Selected from the contextual menu. Refer to #anchor-14-anchor.

When multiple charts are overlaid using the Recording Manager, the last-selected row becomes the target chart. Note that when combining graphs, the units stay the same.

Zooming

You can affect how zooming behaves using the Lasso Zoom button and the Zoom Control pop-up menu together. By default, you can zoom in and out using the mouse scroll wheel. Scroll the wheel up to zoom in, and down to zoom out. Figure 178 shows an example of zooming into a chart. The preview chart shows which part of the chart is being displayed The options available with Zoom Control include:

• Reset Zoom. Resets the zoom level of the chart to 100%;
• Auto Zoom Y Axis. When you scroll using the mouse, this option will automatically zoom the y-axis to the maximum value in the zoomed x-axis values;
• Zoom Both Axis. Both the X and Y axes are zoomed in this mode. This is the default;
• Zoom on Y Axis. In this mode, only the Y-axis is zoomed. The X-axis remains constant; and
• Zoom on X Axis. In this mode, only the X-axis is zoomed. The Y-axis remains constant.

Logarithmic axis

You can choose to display the Y-axis of the chart on a logarithmic scale. You can choose to display the results in base 10, 2 or as a natural logarithm (base e). Use the Log Y-Axis pop-up menu for this, which can be useful where data ranges are wildly erratic or contain extreme spikes. Figure 179 shows a chart in log base 2.

Gridlines

You can view or hide the grid lines on the graph using Toggle Gridlines. This pop-up menu allows you to view the major and minor grid lines on both axes. You can create various combinations using the four options in the pop up menu.

Date range

The Hint button displays the date range selectors and controls, which enables you to:

• fine-tune the range of X-values displayed; and
• read values from the graph by "tracing" points on its surface. For example, Figure 175 shows the cursor positioned over a peak in the graph and the value at this point is shown in the detail area.

Click the button again to hide these controls.

Changing units

To change the units on the Y-axis, make the appropriate selection from the Units pop-up menu. Note that it is your responsibility to choose appropriate units.

Multiple charts

When a graph contains at least two data sets, you can obtain alternative views of them. The data set associated with the original target graph is treated as the reference and the other data sets are interpreted with respect to that baseline. Each command in this menu opens another Charting Tool containing the chosen view. Use the Statistics pop-up menu to choose either a:

• Difference graph - the X-axis remains invariant and Y=0 represents the baseline. Differences between each overlaid data set and the reference point are plotted; or
• Scatter plot - the Y values from the target graph are placed on the X-axis and (X,Y) coordinates are plotted based on common X values in the original data sets.

Note that Difference graphs may be dragged onto other graphs (and vice versa). However, Scatter plots can only be the targets of graph-dragging actions.

Changing chart types

Use the Chart Type pop-up menu to choose the type of chart to be displayed. There are 4 options available:

• Line is the original form (usually a time series);
• Cumulative displays the cumulative total volume (on the Y-axis) over time;
• Exceedance keeps the Y-axis constant but calculates the probability of exceeding Y-axis values on the X-axis; or
• A Frequency histogram shows how the data values are distributed. Change the value in the Histogram Interval field and click Apply Chart Settings, to re-draw the chart with the new interval.

Figure 180 shows each of the chart types.

Legend

To toggle whether the legend is displayed or not, use the Hide/Show Legend button. This is useful when multiple graphs are overlaid, and the legend consumes a considerable amount of space. This is equivalent to right-clicking the chart and choosing Legend in the contextual menu.

Preview chart

You can toggle the appearance of the preview chart using the Toggle Preview Chart button. Just as with the legend, it is useful when multiple graphs are overlaid.

Customising charts

You can customise the appearance of individual graphs using Edit Graph Properties. This button opens a panel where chart settings (eg colours) can be adjusted. It can also be accessed by right clicking on the chart, then choosing Properties in the contextual menu.

The Graph Settings dialog (Figure 181) contains two panels: an index panel on the left and a properties panel on the right. The index panel on the left selects between groups of related properties. These include:

• Title - Customise controls for chart titles (Figure 181);
• Area settings - You can create areas, which may consist of many series. This will be displayed as separate charts. You can also customise controls for both the X and Y axes (Figure 182); and
• General settings - Customise chart display information (Figure 183). These settings are applied to all new charts as their defaults and can be accessed using the Tools > User Chart Settings... command.

Saving and printing graphs

You can save and print graphs using the Save and Print options pop-up menus. The former offers a number of ways in which data can be saved from the Charting Tool. This includes saving as data values, as an image, or as a template for use by the Chart Manager. The latter provides access to printing tools.

Table tab

The Table tab provides a textual representation of your data. In the simplest case where you open an instance of the Charting Tool with a single time series, the Table tab will contain two columns, one with time-stamps and the other with observations corresponding with that time-stamp.

If you assemble two or more graphs in the Graph tab, the Table tab will contain additional columns, one per dragged graph, with the observations aligned with respect to time.

Data can be sorted using the values in the two columns by clicking the column headers. Successive clicks in the columns will switch between ascending and descending sort orders. The small grey triangular arrow at the end of the column indicates the direction of the sort order.

Data can be copied by right-clicking anywhere in the table and selecting copy form the pull down menu that appears. The data copied will depend on which rows are selected.

• To select the entire table for copying click the top left rectangle to the left of the column headings. The entire table will be highlighted in blue. Now right-click in the blue area and select copy.
• To select a single row for copying, click the empty rectangle to the left of the row. The selected row will be highlighted in blue. Now right-click in the blue area and select copy.
• To select a single cell for copying, click inside the cell. The selected cell will be highlighted in blue. Now right-click in the blue area and select copy.
• To select a single column for copying, click the topmost cell in the column and drag down to keep selecting cells underneath to the required point. The selected cells will be highlighted in blue. Now right-click in the blue area and select copy.

Time-stamps can not be edited but you can paste data into the remaining columns if required.

Right-clicking in the column headers will also display some summary information about the data contained in the table. For example, the Date column displays a count of rows displayed and the Data column displays arithmetic statistics and allows the units of measure to be changed.

You can export data to .CSV and tab-separated formats by clicking Export.... Clicking Open transfers your data to a Microsoft ExcelTM spreadsheet.

Statistics tab

The Statistics tab shows a summary of statistical data for all the selected data rows. Just as multiple results can be displayed graphically (by overlaying), the statistics for these results can also be simultaneously displayed for comparison. The example in Figure 185 shows that there are 3 results available (in the left panel). Since only one is selected, it is displayed on the right panel.

Results in the Statistics tab can be viewed in 4 different formats using the buttons at the top left corner:

• Monthly summary - formatted in 12 monthly rows and provides tabular statistics for all the years in the run combined;
• Yearly summary - provides annual statistics with one line representing each year in the run;
• Month by year summary - allows one row for each calendar month in the run regardless of the number of years in the run; and
• Total - provides statistical data for the entire period run.

The display can also show multiple results in the same screen, by selecting two or more results (Ctrl + click) in the left hand margin of the window (Figure 186). In order to view multiple results in this manner you need to have previously overlaid two or more graphs in the Graph tab. Instructions on how to do this are described in Combining graphs.

If the table title (in the Statistics tab) is clipped, make the window larger.

Understanding bivariate statistics

When two data sets are selected in the Statistics tab, a table of bivariate statistics is calculated. It is important to understand the relevance of the information presented in this table.

The left-most column reports a value for Pearson’s Product Moment Correlation Coefficient which is usually denoted as "r". This value is calculated by performing a linear regression between the selected data sets. This calculation is independent of the dragging order. Values of r are in the range -1.0...+1.0 and are generally interpreted according to the scale shown in Table 105.

Values of r are only meaningful if the values in one of the data sets can be used to predict the values in the other data set. In other words, one of the data sets contains X (explanatory values) and the other Y (response values), and a linear function f(X)→Y exists. An example of a case where r might be useful is measurements at two gauging stations where one is in a tributary and the other in the main channel below the confluence, and the question to be answered is whether there is a linear relationship between those observations (eg "to what extent can flow in the tributary predict flow in the main channel and vice versa?").

When r is meaningful, the Coefficient of Determination (R2) can be obtained by squaring the value of r.

An example of a case where r is not meaningful is when comparing the results of running a Source model with observations taken in the real world. This is typically done at a Gauge node. In this situation, the observations in both data sets are response values so the assumptions for the existence of a predictive linear function between the data sets do not hold. It is Source that implements the predictive function rather than the least-squares algorithm employed by the calculation of r. This situation is where the right-most column in the Statistics tab is applicable. The Nash-Sutcliffe Model Efficiency Coefficient (Efficiency) is another name for R2. It is calculated directly from the two data sets (ie without first performing a linear regression). Dragging order is important and you must drag the graph containing the modelled or predicted observations (the result of running Source) onto the graph containing the observations of the natural system being modelled, and not the other way around.

To summarise: either r is useful, or Efficiency is useful, never both. It is up to you to decide which is appropriate in each situation. It is also up to you to ensure that you use the correct dragging order when using Efficiency.

R2 (whether calculated as Efficiency or r2) is a measure of model strength. If it is calculated by squaring r, it will lie in the range 0.0...+1.0. Values for Efficiency can range -∞...+1.0. It is usual to multiply the result and express it as a percentage. For example, an appropriate way in which to interpret a value of R2=0.7 would be to say:

70% of the variability in the modelled data set can be explained by the variability in the observed data set, with 30% due to unexplained factors.

This implies that when R2=1.0, the model has perfect predictive power and leaves nothing unexplained, but when R2=0.0, the model lacks any predictive or explanatory power. When calculated as Efficiency, R2 can also be negative. This occurs when the combined errors in the modelled data set are larger than the variability of the observed data set, and also suggests that the model lacks any predictive power.

While a value of R2 close to 1.0 suggests that a model has good predictive power, you should not rely on R2 completely. Two time series may produce an R2 which suggests strong predictive power, yet discrepancies may be obvious under visual inspection. Similarly, two time series which are very closely aligned with respect to the Y-axis but which have even a small misalignment on the X-axis may produce an R2 which suggests that the model lacks any predictive power. In short, you should always rely on your own judgement.

The Volume column contains a measure of the relative difference between two data sets. Like Efficiency, this measure is sensitive to dragging order and you must drag the graph containing the modelled or predicted observations (the result of running Source) onto the graph containing the observations of the natural system being modelled, and not the other way around. Values for Volume can range from -100...+∞ where 0.0 indicates that there is no difference in the totals of the data sets. The equation used for calculating Volume is:

Recorder Results

The Recorder Results window (Figure 187) is a special case of the Charting Tool. At present, it is only available for the Continuous Sharing Recorder recordable attribute of the Resource Assessment tool but this functionality is likely to be extended to other collections of result sets.

In effect, the Recorder Results window pre-assembles related collections of result sets and arranges them in an hierarchical display. The hierarchy contains two kinds of entry:

• structural elements are associated with a + or - symbol.
• result set elements are not associated with a + or - symbol.

You can perform the following actions within the hierarchy:

• Clicking a + or - symbol expands or contracts the hierarchy.
• Selecting a result set element graphs the associated result set. You can use both control-click and shift-click to extend the selection to graph multiple result sets.
• Selecting a structural element causes all entries below it in the hierarchy to become selected. All result set elements contained in the implicit selection are graphed.

Note the construction of any given graph requires an amount of CPU time that is proportional to the size of the result set. Selecting a structural element that implicitly contains a large number of result set elements may take a significant amount of time to compute.

Although the collections of result sets displayed in the Recorder Results window are related, this does not necessarily mean that all result sets employ the same units. When a selection of result set elements contains inconsistent units, the label for the axis will change to "Inconsistent". This situation is shown in Figure 187. This is because eight out of the nine selected result sets are expressed in megalitres whereas the Inflow Share result set is expressed as a percentage.

Each graphed result set is also represented in the legend. Each entry in the legend is associated with a checkbox which can be used to show or hide individual graphs. Changing the state of a checkbox will either:

• Trigger a check for inconsistent units. For example, turning off Inflow Share in Figure 187 would result in the Y-axis label changing to "ML". Turning the graph on again would return the Y-axis to "Inconsistent"; or
• May cause the graph axes to be re-scaled. For example, turning off all graphs except Reconciliation Adjustment (the blue trace that hovers near Y=0) would result in MaxY=8000 megalitres rather than the 60,000 megalitres shown in Figure 187.

You can adjust the relative proportions of the window that are devoted to the hierarchical display and the tabbed area by dragging the divider.

Aside from the differences explained in this section, the behaviour of the Graph, Table and Statistics tabs is identical to that of the like-named tabs in the Charting Tool.

Chart Recording Manager

The Chart Recording Manager allows you to compare the result sets of different scenario runs using the Charting Tool. You can save a result set, re-run the scenario and compare the results using, for example, Draggable. This can be done as follows:

• Run a scenario and open the required chart.
• From the Graph tab toolbar, click on the Save options pop-up menu and choose Save as Template.
• In the resulting window, enter an appropriate template name and click OK (Figure 188).

• Close the charting tool window.
• Choose View > Chart Recording Manager to display the Chart Recording tab. This will be located next to the Recording Manager.
• Re-run the scenario to display the chart (Figure 189). Click on it to open the charting tool.

• Back in the scenario, change the appropriate parameter in a node and re-run the scenario. This will update the chart in Chart Recording.
• Open the chart once again.
• You can view charts of different scenario runs and compare the results using Draggable.