Report help ? Same Day resolution

[Mark (ESC)]

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?

[Steve Giller]

I think this setting should work:

[Mark (ESC)]

Almost there, I can see the logic, thank you. 

Sadly getting a 

[Victor]

@Mark (ESC) is the first criterion that seems to have an issue ... is the report using the SQL schema designer or the Requests Entity?

[Mark (ESC)]

@victor the report is based on Requests Entity?

[Victor]

@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.

 

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

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

[Bob Dickinson]

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