Joyce Posted January 22, 2020 Posted January 22, 2020 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 Posted January 22, 2020 Posted January 22, 2020 @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 Posted January 22, 2020 Author Posted January 22, 2020 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 .
Bob Dickinson Posted January 28, 2020 Posted January 28, 2020 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 Posted January 28, 2020 Author Posted January 28, 2020 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
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now