Jump to content
Martyn Houghton

Measures - Date Range start and end variables in measure criteria

Recommended Posts

In order to undertake more complex measures and to be able or retrospectively regenerate them, can we request an enhancement to be able to insert the 'Date Ranging Column' start and end date/time stamps in the 'Query where clause'.

For example we want to set a measure that obtains the number of open requests at the end of a period, so we would do a count on requests where the Data Logged is before the end of the period and the date closed is null or after the end of the period.

Cheers

Martyn

 

Share this post


Link to post
Share on other sites

Hi @Martyn Houghton

You can already generate a measure that records the number of requests at the end/start of a sample. 

In the below example, I have a measure that runs with a Monthly Frequency. By leaving the "Date Ranging Column" empty, the measure will simply record the count of the criteria at the point the sample runs (in this case, 00:00:00 on the first day of every month). 

Obviously this is a point in time measure, so it's not something you can retrospectively generate as that information is not stored against requests themselves. So be careful that you do not resample this measure, as you will lose all of the samples you had previously recorded

Screenshot_10.png

 

Kind Regards

Bob

 

Share this post


Link to post
Share on other sites

@Bob Dickinson

Thanks for the update. We already have the point in time ones in operation, but we have changed our criteria and also migrated other service desks over, so in essence I need to go back in time to recreate them.

Having access to the variables or having new SQL measure type with access to the period values would allow this to be done retrospectively.

Cheers

Martyn

Share this post


Link to post
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...