Sometimes, you may need to show data of different frequencies in one chart. For example, it may be monthly and daily dynamics of stock price returns, or annual and quarterly sales figures.
This article discusses the following questions:
- How to understand which data frequencies are available?
- How to convert one frequency to another?
- How to plot different frequencies in one chart?
How to understand which data frequencies are available?
To be able to plot different fequencies of a time series in one chart, these frequencies should be available in the dataset. To understand which frequencies are available for a time seires, query this time-series in the Dataset Viewer and look at the "Frequency" box at the top left corner.
There are the following frequencies which supported by the platform:
- A - annual
- H - semi-annual
- Q - quarterly
- M - monthly
- W - weekly
- D - daily
It is worth mentioning that there are two types of data frequencies: (a) original, and (b) calculated ones. Original frequencies are those which are originally available in the data source while calculated are those which can be derived from original frequencies using aggregations. So, if a dataset originally has only daily frequency, all other frequencies will be available for visualizations through built-in aggregations. On the other hand, if a dataset originally has quarterlty frequency, then only three frequencies will be available to you: quarterly, semi-annual, and annual.
To check which original data frequencies are available in the dataset, refer to "Details" tab of the Dataset Viewer.
How to convert one frequency to another?
There are three ways data frequencies can be aggregated to one another:
- Sum
- Average
- Last value (if you , for example, are aggregating from daily to monthly frequency, it will show the last day of each month)
To change the way frequencies are aggregated, pick the one from the "Transformation" box.
How to plot different frequencies in one chart?
To plot several different frequencies in one chart, open a visualization in the Dashboard Builder and edit it.
In the "Dimension Filter" tab, select "Custom" time period in the top right corner.
Then, in the "Time" panel at the left, holding "Ctrl" button ("command" on Mac), click an additional frequency you want to plot on a chart. It will be added as a separate series on a chart.
Similarly, you can plot multiple frequencies in one chart in the Dataset Viewer.