Page Comparison

Transforms allow you to modify (or transform) the view of the data. Once generated, they can be used as a template for another action, such as applying to custom charts. Transforms are a form of data manipulation. They are centrally managed using the Transforms Manager and are saved with the project.

...

Anchor
DataManipulation DataManipulation

There are two main methods for manipulating a single result in Results Manager; applying a transform and changing the chart type. A chart type must be selected and can be changed in the Chart tab. Applying a transform is optional. Both of these changes will affect your result in all three data views (Chart, Table and Statistics; Figure 1). For example, if you add a date filter and change the chart type to cumulative, the statistics will update to reflect both these manipulations, ie. the mean will be the mean of the filtered, cumulative data. Note that filtering your data using the search feature in the Table tab does not affect the chart or the statistics. 

Figure 1. Results Manager, single result data manipulation

 

 

The same two methods of data manipulation apply in a custom chart. However, any transforms that are applied to single results remain applied to those results in the custom chart. You can then apply transforms to the custom chart, and these will affect all results in the custom chart, regardless of what other transforms were applied to the individual results (Figure 2).  For For example, if you had observed flow at a daily time step, and the rest of your model was at a monthly time step, you could load the observed flow time series and aggregate it to a monthly time step using an aggregator transform. Then, you could add it to a custom chart with modelled flow, and investigate the low flows by applying a number filter transform to the custom chart. Note that for custom charts, while the Data tab lists the results in the custom chart, it does not indicate whether a transform has been applied to those individual results.

Figure 2. Results Manager, complex data manipulation

Image Modified

Creating transforms

...

Figure 5. Aggregator transform

Date range Date range filter

This transform returns values within the entered date range (Figure 6). Note that the start date must be before the end date. Select Add to enter another date range, this can be done multiple times. The filter will return all values that match any of the date ranges entered (ie. this transform returns values within either the first date range or second date range, etc.). In comparison, if you create two date range filter transforms each with a single date range, and apply both transforms to a result, only values that are within the overlap between both date range filters will be returned (ie. applying multiple date range filter transforms returns the overlap between the first date range filter and the second date range filter, etc).

...

Figure 9. Repeating range transform

Allow nulls:

This functionality allows the aggregation to ignore/show any null values. It works with the repeating date range filter and all aggregation methods.

Image Added