Standard Reports

SP-Bench's standard reports are the most flexible and customisable of the reports available.

Using the standard report you have a single, large chart area showing just one of the measures (e.g. Cost per support hour) but for all of the services in SP-Bench.

The training video on the right will take you through every aspect of the Standard Report, including how to apply filters, choose different measures, group and sort your results and how to customise the chart's appearance.

Layout

1. Report selector - This list lets you quickly switch between the reports available, while keeping the filters you have selected.
2. How To's - Here you can find links to useful hints on how to do common tasks with the report. The How To's open in a new, small window, which you can refer to at any time.
3. Toolbar - The report tools allow you to save or copy the chart, change the layout, and more. Hover your mouse cursor over the icons to see what they do:
   1. Save entire chart image - Allows you to save an image of the chart to your computer.
   2. Properties - Allows you to modify the chart layout including the title, legend and data labels.
   3. Export to Excel - Allows you to save a copy of the data grid as an Excel file to your computer.
4. Field List - Here you can find all the fields available for use in the report. These can be dragged and dropped onto the "Legend Fields (Series)" panel, the "Axis Fields (Categories)" panel, and to the Filters list if necessary.
5. Filters - Here you can quickly filter out results you aren't interested in, just click on one of the fields in the filter area to drop down a list that will let you tick what you want.
6. Chart/Grid tabs - The "Chart" tab displays the chart and the "Grid" tab displays the data on which the chart is based.
7. Chart area - The chart itself is also interactive, hover over a column to view more details about what it displays, including its exact value and the number of data items behind it.
8. X-axis - The labels on the x-axis will let you dig down into the data by expanding a region into its component Authorities and expanding Authorities into their Services, just click the + and - icons to expand or collapse an element. You can also hover over the label of one of your services to see its full name - note that this will only work for your services, not ones from another Authority.
9. Legend Fields (Series) - The fields here are the measures you are reporting on (e.g. Cost per support hour, PI Percentage, Provider QAF Performance Level or Outcome Achieved Percentage). Click on the "Measures" button to change what measures are shown or to include more in the report.
   • When reporting on PIs, QAFs or Outcomes, there will be a second button here where you can select which specific indicator(s) you want to display.
10. Axis Fields (Categories) - The fields here are the ones displayed on the x-axis of the report. If more than one field is added then the results will be grouped in the same order as the fields, e.g. Services by Primary Client Group.
11. Sorting - Clicking the arrow icon allows you to sort your results in ascending or descending order.
12. Total item count - This is the current number of items (services) that match the filters and that are included in the report.

Using the report

Take a look at the Using the Reports section for more details of how you can:

• Filter to show the services you are most interested in.
• Drill into the data to see values at the regional, LA and service levels.
• Switch between reports.
• Choose which measures to display.
• And more...

Back to top