How to set a common currency in a document?
Click on the Series list and select your desired currency from the Currency drop-down list. For more information: Currency conversion
Category: FAQ
How to synchronize values of two y-axis?
Click on the y-axis and go to the Presentation properties tab. In the Axis panel, set ‘Synchronize’ to ‘Values’. To display two y-axes with different values, please see: How to display multiple y-axes? For more information: Elements of the chart
How to aggregate a series?
There are two main possibilities to aggregate series: 1. Aggregate analysis Specify the period over which you want to aggregate the series. You also have the option of making this a rolling sum. 2. Formulas AggregateSum(series) Sums up all values from the start of the series. AggregateSumAnnual(series) Sums up values of a series on a … Continue reading “How to aggregate a series?”
How to change how time range is displayed on the x-axis?
Click on the x-axis and open the Presentation properties tab at the top of the window. In the Labels group you can manipulate the scaling of the axis. The automatic setting will label the scale with the frequency that allows for the best view. Unchecking it will enable you to use the manual step option which … Continue reading “How to change how time range is displayed on the x-axis?”
How to calculate percentage change (Y/Y, Q/Q, P/P, M/M)?
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)?”
How to reverse or invert a series?
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
How to change the frequency of the data in a document?
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?”
How to change the default font used in the text elements of my chart?
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
How to include discontinued series in my search results?
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’:
How to reverse / invert the y-axis?
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