Jump to content

Previous years data on Measures


Recommended Posts


I am trying to create a measure to count amount of tickets opened per month for various years (2017, 2018, 2019) to compare the growth in demand.

When I set a measure as follows, for 2017- no data can be found. Are previous data not available on the application for dashboard purposes?



If I change the dates for 2019, I can the values as expected:




Link to comment
Share on other sites

Hi Dean,


The team name has not change since the beginning. My suspicion is on the cut off point for data which can be accessed from 'Measures'. When re-sampling measure data, it only goes as back as 01st Jan 2019 .


Link to comment
Share on other sites

Hi @Joyce

The method you are using here is not going to work unfortunately. What you are looking at in the screenshot is the past 12 months worth of samples. It doesn't matter what you specify in the criteria here, it will always start at the most recent sample based on the frequency and work backwards based on the number of samples you have specifed. If you hover other the samples, you will see the month they have scanned. 

If we take the 2017 measure, it is effectively saying "In the past 12 months from today, how many were logged in 2017?" - the answer is going to be 0 for every month

This image may make it slightly clearer



What you may need to do here is:

1) Increase the sample size of your Measure (from 12 to 36) so it collects the past 3 years worth of data instead of past 1 years

2) When you create the widget based on the measure, you can use the "Date Range Setting" to specify the date range of the samples to use (e.g. you might have one widget with a date range of 01-01-2017 to 31-12-2017, and the next widget with a date range of 01-01-2018 to 31-12-2018, etc)


I hope this helps!

Kind regards


Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...