Previous years data on Measures

[Joyce]

Hi,

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:

 

[Deen]

@Joyce I take it the team name has remained the same since 2017 as that is the only thing I can think that might have changed.

[Joyce]

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 .

[Joyce]

Hi @Deen

Any suggestions?

Thanks. Joyce

[Bob Dickinson]

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

Bob

[Joyce]

Hi @Bob Dickinson

This does make sense, and I did suspect might be the reason for zero values.

I will try your suggestion, and see ho it goes.

Thanks.

Regards,

Joyce