Hi,

We've just started to use SDP for the Requests module and I now want to look at extracting information for reporting purposes.

I want to produce a week by week report displaying our performance against our service level (95% of requests are resolved on time).

I'm guessing that I need to extract information into Excel to do this, but when I run a SDP Report Module report into a CSV or Excel file, the date fields are text based and Excel doesn't recognise them as dates.

How do other people produce their SLA/KPI statistics? Do you mess around in Excel constructing useful date fields, or do I need to use a Query report instead?

Thanks in advance,

Rich