Jump to content

Report help ? Same Day resolution


Mark (ESC)
 Share

Recommended Posts

Is it possible to create a report showing same day resolution of tickets over a period of a week.

ie  "Requests -> h_datelogged value equals h_dateresolved"

But have the report scan a time period for the last week, so I can avoid having to run this five times for each week.

Guessing I need to use custom criteria?

Link to comment
Share on other sites

@Mark (ESC) I'm not sure how you built the first criterion then since it does not work when using the entity. Change it to use SQL schema designer. Note this will reset you report configuration.

When switching to the schema designer you will have an additional tab available "Select Tables". Here, select "Requests" table.

image.png

 

On "Select Filter" tab, build the two filters like this:

image.png

image.png

The rest of the tabs (Columns, Ordering) can be configured as before.

Link to comment
Share on other sites

Hi @Mark (ESC)

As discussed on our call yesterday, this is quite a difficult report to build in general - because to esablish calls that were logged and resolved on the same day, you need to use a SQL "Datediff" function which our reporting UI doesn't easily accomodate. 

I have found a workaround, and whilst certainly not ideal, it should return you all of the requests you would expect. 

Let me know if there are any issues

Kind Regards

Bob

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
 Share

×
×
  • Create New...