There are two main possibilities to calculate percentage changes: 1. The Rate of Change analysis Set the Method as ‘Change over period %’, and then choose the length. 2. Formula You can also calculate percentage change over period with the formula: cop(series, length) Examples for Y/Y, M/M and Q/Q changes, respectively: cop(segdp, YearsLength(1)) cop(segdp, MonthsLength(1)) … Continue reading “How to calculate percentage change (Y/Y, Q/Q, P/P, M/M)?”
To reverse the sign of a series, use the following expression in the Series list: -series To invert a series, use this expression in Series list: 1/series For example: 1/eur
Click on Series list and select the desired frequency from the frequency drop-down list. You can also further adjust conversion method used in the file in Conversion settings tab. This operation takes precedence before all other calculations, including formula functions in the Series list. If you wish to change the frequency as an intermediate step … Continue reading “How to change the frequency of the data in a document?”
Click on an empty area in your chart (i.e., below the x-axis). This opens the general chart properties under the Presentation properties tab. In the Appearance box, change the default font. You can use the ‘…’ button to select from the full list of installed fonts. For more information: Elements of the chart
In Search tab, choose ‘Include discontinued’ from the Filter drop-down list: In data-tree, enable the filtering option (funnel icon) and tick ‘Include discontinued series’:
To flip or reverse the y-axis: Select the y-axis on your Time chart. Switch to the Presentation properties tab and locate the Scale panel. Under ‘Reverse’ select ‘Yes’. For more information: Elements of the chart
There are two main possibilities to achieve this: 1. The Conversion settings tab in Series List You can set the ‘Missing Value Method’ as ‘Zero Value’. 2. Formula You can also use the formula: Null0(series) For more information: Formula analysis
To convert a ratio to a percentage, you need to multiply the ratio by 100. There are two main possibilities to achieve this: 1. The Arithmetic analysis Set the 2nd operation field to ‘Multiply’ and ‘Value operand’ to 100: 2. Formula You can also use the formula language, by appending ‘*100’ at the end of … Continue reading “How to turn series into percentage?”
In a chart, click on the series you wish to delete then press the ‘Delete’ key. If you wish to remove a series from the document completely you will need to delete it from the Series list.
In Macrobond you can create index in two ways: 1. If your purpose is only to scale series to start at a specific value, like 100, then the Rebase analysis should be used. You’ll find more information on using the Rebase analysis here. 2. The Index Builder analysis can be used to create indices that … Continue reading “How to create an index?”