Difference between revisions of "Data Browser Calculations"
(→Overview) |
|||
(9 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
[[Category:Fusion Data Browser]] | [[Category:Fusion Data Browser]] | ||
+ | __NOTOC__ | ||
+ | ==Overview== | ||
+ | The Calculations Button [[File:FDB Calculations.png|50px]] is available on the Table and Time Series Charts toolbar and is also one of the [[Data_Browser_Export| Export Data features]] for certain formats. | ||
− | + | Clicking on the the button will display the options available. | |
+ | |||
+ | [[File:FDB-Calculations-options.png|600px]] | ||
+ | |||
+ | One or more options can be chosen. | ||
+ | |||
+ | '''Note''' - certain options work with a Frequency dimension. I If the system does not find a dimension for frequency in the associated data structure, you will be presented with a list of dimensions that will enable 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. | ||
+ | |||
+ | [[File:FDB-Table-Chart-Moving Average.JPG|500px]] | ||
+ | |||
+ | ===Precision=== | ||
+ | Enables you to set the number of decimal places. | ||
+ | |||
+ | [[File:FDB-Table-Chart-Precision.JPG|500px]] | ||
+ | |||
+ | ===Interpolate=== | ||
+ | |||
+ | There are no additional options, just on or off. | ||
+ | |||
+ | ===Convert Frequency=== | ||
+ | |||
+ | You can use this to convert all rows to the selected Frequency. | ||
+ | |||
+ | [[File:FDB-Table-Chart-Convert-Frequency.JPG|500px]] | ||
+ | |||
+ | |||
+ | In addition there is an Aggregate Function which presents further options which can be used in the calculation. | ||
+ | |||
+ | [[File:FDB-Convert-Frequency-Aggregate.JPG|500px]]. | ||
+ | |||
+ | ==Table Chart== | ||
+ | Using External Trade which is available from the [https://demo11.metadatatechnology.com/FusionDataBrowser/?share=N4IglgJiBcIMQGMAWBDATgFxAGhBgngA4CmMIAggOYDiakACmAG4D2GAKigEYA2puARwCuxNPhigAiiLrEAzjADaoSGRQBWAGwoALAA4EAdgTEAzMYAMEC4YgIdXLgnUBOTTuIQuAMwj8QECgYKN48LADuEuBQsOwASgAiOCAolMQAdgj4AJIxIACiAMIAQslMonJgLOlkAIwAdBYgAL7NALq4APIkaEFV6QrQwM24hSx+AMrEfAgY-YPDIyAILDxCALYDwRik0MrLq7lkckgsmCt+yeGQGEgwAEwWFrhIkLsYaCK4hGDp6Z4wdJCHg8XByM5YaBAkFgiHZdJ+AAegOBoJSlEoADEhJkUTCQGgIrQWEJCDBvCgeHJiLhCeFiaT4Ui8WifqxIRSqTSQGy2EziMioajcKEBTBaiNQCseEdYJi4vlJFcbndoLV1M8QK9LtBOdTvr9-jFoWjwZgWbDMPzBSbcKksTiEBaCUTCaTyZT9S76W7CNbnbyOZ7uYH-UL8aLBRLsFLDnkFZiAPrkBXkZUQW7ijUvN4erkGv4A8OmiHOs0YMO29EO3HF2muklk3XB+s+xuV4U85hsPNe0MIsV1kCR8WSg4yvLkBIAKQAqhN2ABZfIAOXY6czauzWtzzfzXcLxs75bLcIHNs79uxtardIZTb13Lvvo7+MDvZD3Yr5+dI7VY+lWUQHiBJE0xAAZToAHUN1VdVNW1XZHwLI1T3NIdy1fNEr0dZ1n0bD9W3vLCDXZQiu3ZEjhz4KMALjMgQMTeg4k6BJZ0KddcGuDM4O3RDyJ+Q80MhKtMJ-IccJvTt8PdPcvRkv1xKrd85M-SilM7P9o1jCcyEKTpZzXZNU1grMEN3ZCD1QjDSxsq0NPxSSnSHBTyIUqiVMs-tmSHLS6N02AFwmRNshXBdsnYWd2GyToV1MrdzJ1LzDSLUTbLS+yfKrJy8IbWTLPchzWS-ASvyovyY3HIDGImWdMUxbIAA14vgnMkpbKzUuPdLusywdsoxa9nNvPKHw6wqss7TyOu8-rNJo0dKsAvJ5UVRN4seRL3k+T8hLskTeu-SbHMG3CXNGtzRo8krVNIvkipFBb-yW+jYATYz8nIdauJVB4nja7avk6o98RPfaqJy8623y8aroeiie1uhGjrmiMnu0qrJxnecl1XdhvpAbjN02gGYA+IHBOsjKDtBs9juw06pPxVykYm1HirIpHZovNHBwx5aGMSMDIKggmidVEmdx1cndqpw7hIhxnhuki7Wbh+m7qDfdud-dH-OqoXmNY9j8Y2-6pcB2Wutp9DqcVmtleZ1WCvV9nNdK9SNeovn9byfTDPxlNPrF37oEl-joBllDrZLW3Dvtobcuhsb9zZnmOcR5LPbd73aJegKQCCkKwuiyLotikOeL+rayZ26OQdjmnG4Ts6RuTy7k+uzms-ur2Kp0g3QNq+qmsr4nzYjqPgeEhX4chtv7w74j4em7Wyvh-vMYY7JlyY-I4hipIfqrhLSa5lKG8tJur5bpm0RZl3O5Xm6e5R9PHp9-Pqp3-I94P1jExyDJMfceNdI512nvtWeXt54q3bmrJ+XtV59nXn3PWX88jRV3vQfeh9EzEGAYTUO4ddxT0pjHK+0Cc6wKdvAx+y8kEvxmqgnOm8BaxB-mBTocRFzkE4kQk+JDpYQPIZfEAYM7ZzyVknReCCGE52QWpXurD0EDyxnORMCR8jsHINkcCZswFkIvjPcGUiHYyN9EvF8z9u7MOzu-XOi01FkGKKmAA0hMAxZ8jF7WplQhxND77O1hoghRTC172N1p-ZxsB9LgXAkUcucUQESwnqQkRxioGmJgdIqGsj6HWMYbYiJyiHFsNeiAfSi56B6NCtQRM3DqBeItrXCmmS-HZOobkheli5GFLCcUlBkTfKqK3rABI2QJjBUac0yeGTfHy06QE7pcD8khPkQ4xRmtyqjPYSABInRFyJgmPvEKCRPEpOrt4+ZcsbbX3EXTLp5i8m9IKe2Gxmc7GlKiXnGJIB6CzmKOBRMRRSiXLDmk4RbSFl3P8c6QJRFXnrP6Zs8JQzvkjOiWM-5gLgWLlnLM9J0LbmNzhRJFZtC1mp1dqiwZSi34-KcdigFQKmK4uyIUQlUKrZiIkfHMxicXkET6e8opnySkMsxb87FhkIrFy0Y1RMxRyAnK5ZbeuJjJE5OeT04VbzGQfK1uiyVVZykFyqTU8CfCYrJIEaA65xKKEPLjnc2+jsgl0ORaKgZ4rjU7KxXsrRhQd7kHAhcu1qTDE3KdXy11ArW6rKRdS0JtLfX0v9dKvZEwDJxEKL-cg1BVyFAAJpqtaTyzV-LtWCt1TDZNGyAxovTRvXZFTS4JLLeAx1vKepxurQmylSb5I0sbXS7ZLaA1toigkxMFr9HgqEeqyBHStVPJrYmvVXqDViqNc2tBk6C6yv4eLK5LSu0Vqyau5ZOqN11uHSm0dabx37szRUo9iZ8XgWPcQyFS7RGVr7WugdHqqX3obUOLZyMM1Mr2Z0YowUFx8PnJ2nxJLKFLPhRSkDQ6nwjog0259KiD1ATg8FfSK5MQoejT2l1zd4130RZu+tKLH27sI2U1tBdSNMQVEq9xVHu0Abo-2hj3pQO4YffhsdUGJ2vq4-B2dhyBMXpXVWoDomH5bsUjuj2GLTWcZIwpgAaqG2c+QWp8QsswmFpKMPkueeIjYyRNPMe9amtjMmX2jg6MjRc4wkIdW8GAHYaAJjbF2IsIAA| demo site] adding a function such as % change will have the effect of adding another column as shown in the example below. | ||
+ | |||
+ | |||
+ | [[File:FDB-Table-Chart-Percentage-Change.JPG|1200px]] | ||
+ | |||
+ | ==Series Chart== | ||
+ | |||
+ | In the example below, again using a series chart available on the [https://demo11.metadatatechnology.com/FusionDataBrowser/?share=N4IglgJiBcIMQGMAWBDATgFxAGhBgngA4CmMIAKmALbEDKxaYxAzgMKqY4gCOArg-higAiv0YsYAbVCQyKAKwA2FABYAHAgDsCYgGZtABggHNEBCoBGFhPICcilcQgWAZhFK4IKDChcAbAHsAdyFwKFhyACUAES4UAHNiADsEfABJcJAAUVYAIS4ANwZmMACksgBGADoDEABfOoBdXAB5EjRvUqTmUIQUPwReP06ynuhQGhRmXjRScZAIamSSsrIAMUiAfQBZLIBBWgBVSKyuPoGhkfLoaRAXXhSMLrJCZHrGhrrcVgD3ej9iAgnqMhA1cH5qGAsNAAEwGXDMBBoAJ+PwADzIFgCGAwASoXHiyN4hB+D2h8gM8IW3mIawCaCo3lCKCSSV4-TI+C5gk8KDAfkEsAgEAAtNttiLuTyQFQyhgkAKyOKJVL6nUgA| Demo site] you can see at the top of the chart, additional information. | ||
+ | |||
+ | |||
+ | [[File:FDB-Series-Chart-Percentage-Change.JPG|1200px]] | ||
+ | |||
+ | |||
+ | ==Exporting Data== | ||
+ | If you have applied Calculations, these will be used when the data is exported. |
Latest revision as of 03:19, 30 October 2024
Overview
The Calculations Button 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.
One or more options can be chosen.
Note - certain options work with a Frequency dimension. I If the system does not find a dimension for frequency in the associated data structure, you will be presented with a list of dimensions that will enable 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.
Precision
Enables you to set the number of decimal places.
Interpolate
There are no additional options, just on or off.
Convert Frequency
You can use this to convert all rows to the selected Frequency.
In addition there is an Aggregate Function which presents further options which can be used in the calculation.
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.
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.
Exporting Data
If you have applied Calculations, these will be used when the data is exported.