Difference between revisions of "Data Browser Calculations"
(→Table Chart) |
|||
Line 18: | Line 18: | ||
==Table Chart== | ==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. | 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]] |
Revision as of 08:46, 24 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 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
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.