Data Browser Calculations

From Fusion Registry Wiki
Revision as of 08:58, 24 October 2024 by Vmurrell (talk | contribs) (Precision)
Jump to navigation Jump to search


Overview

The Calculations Button FDB Calculations.png is available on the Table and Time Series Charts toolbar and is also one of the Export Data features for certain formats.

Clicking on the the button will display the options available.

FDB-Calculations-options.png

One or more options can be chosen.

Note - certain options work with a Frequency dimension and if the system does not find a dimension for Frequency in the associated Data Structure, you will be presented with a list of dimensions enabling you to nominate a substitute.


Options

Percentage Change

There are no additional options, just on or off.

Moving Average

You can select the number of periods to be used in the calculation.

FDB-Table-Chart-Moving Average.JPG

Precision

Enables you to set the number of decimal places.

FDB-Table-Chart-Precision.JPG

=Interpolate

There are no additional options, just on or off.

Convert Frequency

You can use this to convert all rows to the selected Frequency.

FDB-Table-Chart-Convert-Frequency.JPG


In addition there is an Aggregate Function which presents further options which can be used in the calculation.

FDB-Convert-Frequency-Aggregate.JPG.

Table Chart

Using External Trade which is available from the demo site adding a function such as % change will have the effect of adding another column as shown in the example below.


FDB-Table-Chart-Percentage-Change.JPG

Series Chart

In the example below, again using a series chart available on the Demo site you can see at the top of the chart, additional information.


FDB-Series-Chart-Percentage-Change.JPG