Skip to content
Back to FlexMR
  • There are no suggestions because the search field is empty.

Time Series and Time Series Summary Tables in NumbersMR

Time Series and Time Series Summary tables allow you to track trends in data over the period that a SurveyMR 2.0 runs. You can choose to show data collected over the lifetime of a survey, or for set periods of time. This is particularly useful for CX surveys, which tend to be ongoing trackers.

You can create Time Series tables for any of the following question types:

  • Single choice
  • Multiple choice
  • Card Sort select questions
  • Scale (per sub-question)
  • Semantic Differential (per sub-question)
  • NPS
  • Grid single choice /Card Sort Categorise (per sub-question)
  • Grid multiple choice /Card Sort Associate (per sub-question)
  • Number range (per sub-question)
  • Ranking questions
  • Constant sum questions

You can create Time Series Summary tables for any of the following question types:

  • Scale questions with multiple sub-questions
  • Semantic differentials with multiple sub-questions
  • Number ranges with multiple sub-questions

 

Setting up a Time Series table

A Time Series table or chart shows one measure tracked over time.

  1. Go to Back Room > Analysis Tools > NumbersMR and click into the analysis where you’d like to add a Time Series table, or create a new analysis
  2. Click the Menu icon to the right side of the question you’d like to add a table for, and click ‘Add Time Series Table’
    Add time series table-1

3. You will then see a pop-up box which looks like this:

Create time series table-1

Complete the fields to indicate:

  • The from and to dates for the time period you’d like the table to cover
  • The interval you’d like to view the data by, e.g., daily, weekly, monthly, quarterly, or yearly

NB: The period to show will update accordingly to align based on the interval you select. The title will automatically defer to the interval and period selected, however, you can update the title to whatever you choose.

 

What intervals and periods are available?

Intervals and periods

NB: If your survey is live and ongoing, the data will update per new day / week / month / quarter / year.

 

Question-specific Table Configuration

For scale-type questions, you can choose to show an average of responses given. For NPS score-type questions you can choose to show the NPS score over time. You can show this instead of, or in addition to the percentage of users who have selected a particular answer.

NPS chart

NPS chart configuration options

 

Setting up a Time Series Summary table

Time Series Summary tables allow you to compare data across sub-questions, over time. They are available for Scale, Numeric and NPS-type questions only, because they allow you to show multiple trend lines in one table / chart.

For the eligible question types, you’ll see an additional option, to add a Time Series Summary table, or to add a table per sub-question.

Additional summary tables option-1

Example of a Time Series Summary table:

Example TSS table

 

Linking Time Series Tables and Summaries to ActivateMR

Charts based on time series tables are available in ActivateMR. This allows you to display KPIs tracked over time, as part of a dashboard-style ActivateMR board. To find out more about selecting NumbersMR tables to show within ActivateMR tiles, you can visit our dedicated Help Centre page here - Adding NumbersMR Tiles to ActivateMR Boards .