The time selection options are placed after the series settings in the Time selection menu, as shown in the image below. The time selection will determine what period we are charting and with the change of Interval our Interval that we are showing in Legend (or Axis) will also change. Remember that with changing the Time selection you need to save for changes to take place.
Another option here is Moving average. Here is the example of how this option works: If for example you have 10 points in a series. It will take sum of the first point + sum of the second point + sum of the third point and divide it with respondents in 1 and 2 and 3. This value will be the first showing point in the series. For the second point it will take 2+3+4 and calculate an average for that point.
Note: You can select to use up to 53 periods in the moving average calculation.
A last control button within the Time selection lets you show the time span within the labels when using a Moving Average calculation. By turning on the settings for label logic, it’s much clearer to tell which dates each period is based upon, making the reports more user-friendly. The charts below show a 3-week moving average. The first chart uses the label logic without showing the times span, and the second chart uses the label logic on the same chart, but with the time span control turned on. After turning on the moving average, you'll have the option to show the first intervals (even though they are not calculated based on the complete number of intervals. By default those will be hidden.
To use this option just select the control “Show time span in labels” shown in the image below.
Include previous periods derived from selected optional time-period filter
To include previous weeks, months, quarters etc. in charts and tables based on report user selection in optional time-period filtering option as described.
A typical use case, the user selects September 2021 in time period filter and the top right chart displays data for selected month and five previous months. Previously the same could be achieved with multiple workarounds but the new native options make setup easier and saves time
The option shows up only when optional time period filtering is added to the current StoryTeller report.
When enabling the new option to include previous periods the number of previous periods to include needs to be defined. What a “previous period” means is dependent on the selected time period filter in the Optional filter, see examples below.
Chart is setup to include 2 previous periods, the end user selects September 2021 in optional filters then the chart shows data for July to September.
Chart is setup to include 3 previous period, the end user selects “Week 28 2021” in optional filters then the chart shows data for week 25-28 2021.
“year over year” comparison is added to charts and tables in the StoryTeller which supports comparing to same month, quarter or year-to-date range in previous years.
Below we see an example where the chart shows a year over year comparison in bottom right chart based on the month selected by the end-user in the Optional time period filter.
The setting to include previous years in chart and table setup is in the time selection panel as shown below. The option can be used both when the time period selection is defined in the chart/table object or when it comes from a time period filter in optional filters.
To the left we see how it looks like when the time period definition is setup in the chart, to the right we see an example where the chart gets the time period definition from the optional filters.
Year-over-Year comparison is supported when time-period selection is Months, Quarters, Years and Year-to-Date. It is not supported when time-period selection is based on Days, Weeks or set to a static date range.