[Report]

Hi all,

Not much experience in the reporting side. 

For a system cleanup, I need to be able to see what workflows and intelligent captures are assigned to services. 

Is it possible to do this from a report?

 

Many thanks

 

[Measures - Backlog]

Hi all, 

I need to view historical backlog numbers per week for the last year. 
Is it possible to create a measure to query the current tickets open at points in time like this?

Any advice and examples of the query would be wonderful.

Thanks in advance

Nick

[Working Time Calendars and Daylight Saving]

Thanks for the quick reply.

Ill be sure to ask our implementation person to explain this when we get to it and pass on anything I learn. 

Cheers
Nick

[Working Time Calendars and Daylight Saving]

Im interested in this topic. @Martyn HoughtonDid you work all this out?

We are in the process of configuring a new instance and have multiple time zones. 

Cheers

Nick

[SQL Query]

This looks good @bob_dickinson

Thanks!!

 

[SQL Query]

Hi,

I'm creating some widgets, Id like to view tickets logged yesterday. 

Today is current_date

Should yesterday be something like subdate(current_Date, 1) ?
Cant seem to get this to work.

Thanks