Reporting

Find the report you wish to run. This can be a ‘Public Report Template’ or if it is one you previously built this will be saved in ‘My Report Templates’.

Choose the date range or search across whole database. Please note: this is based on pathway start date, any patients whose pathways started in that range will be included in the report.

You can then choose your report scope options:

• ‘My Patients Only’ – this will include only the patients whose pathways you are the owner of. This will not return any data for delegates.
• ‘All Patients I Have Access To’ – this will return all patients whose pathways you are the owner of and all other patients you have been given access to.
• ‘All Patients’ – this is only available to select users, this returns all patients on your Amplitude system.
• ‘All Patients of Users I Delegate For’ – will return all of the patients, belonging to all of the pathway owners you currently delegate for.

Then choose to export to MS Excel or save as a csv file.

Click Run Report.

If you have a 4:3 resolution monitor the report scope options window will appear facing inwards, towards the middle of the screen.

Whilst the report runs it will show in ‘My Running Reports’ with a spinning arrow. The time it takes to run depends on the amount of data in the report.

Once complete it will move to ‘My Completed Reports’.

Click the green arrow and confirm to download the report. You will then be able to find it in your downloads folder on your computer.

You can delete the report by clicking the red trash icon.

Please note: The reports server updates once a night. Any changes you made today will not show on a report until tomorrow.

Data Output Options and Re-ordering

When ticking your report items you can change the name of the report items by clicking the three little lines and editing the reporting column name.

You can also change the data type and data output options. The data type will change the format for that column automatically when the data is downloaded. There are three data output options:

Text – This will return the word response the user selected

Value – If the questionnaire contains scoring, this will return the value associated with the chosen response

Code – If there is a corresponding code to the response, this will be returned.

Each selection will return in a separate column, entitled ‘text’, ‘value’ or ‘code’ to assist with data manipulation.

If you un-tick and re-tick the items these options will return back to the default.

Another feature is to ‘Show Selected Items‘ only. With this ticked you can drag and drop items to change their order.

Amplitude Pivot Forms Explained

Making a Pivot Form allows you to choose which instance of a multiple instance form you wish to see on the report.

The Pivot Form is normally the procedure form however you can make any form the pivot. If you do not select a form to be the pivot it will default to the pathway start date.

With a Pivot Form selected you will see various arrows on all other multiple instance forms, as shown below.

Note: Score forms do not have pivot options, all instances of the selected score will be shown in the report.

Make a Pivot Form: A pivot form is a form which all other forms can be chosen around. For example, your patients may have five completed notes forms on their pathways and to pick the one most relevant for your report, you would like to see their results pre and post op. By making the procedure form a pivot form, this puts a marker in at that point and allows you to pick which is pre-op and which are post-op. There can be more than one pivot form but only one pivot form of the same form type. For every instance of a pivot form, a new row in MS Excel is generated.

1. Earliest Instance on a Pathway: This is the earliest point on the pathway that this form was given, regardless of when the pivot form was completed.
2. Earliest Instance Pre-Pivot: This will take the selected questions from the form that occurred furthest pre-pivot.
3. Latest Instance Pre-Pivot: This is the form closest to the pivot form before the pivot form was created.
4. Post-Pivot options: These options are identical to their Pre-Pivot counterparts.

To access these reports first click the reports icon.

Click the report you require.

Instant Reports:

If configuring your Instant Reports for the first time click Configure Your Dashboard. Drag and drop the reports you require; these can be rearranged in any order.

Once happy click Confirm Chart Selection.

Now whenever you go to your Instant Reports these will load using real time data.

Funnel Plot:

Only available to pathway owners.

Choose the Score you would like to plot and which pathways to cover.

How is this calculated?

Score Comparator:

Only available to pathway owners.

Choose the score you would like to compare and select which pathways to cover and choose a date range.

Click Generate.

Your outcomes will then be plotted against other consultants within your trust or registry system.

See above the Excel Workbook we formatted earlier. We have the ‘Report Data’ sheet which we gathered from a report we had built and run in Amplitude. A sheet with our Pivot Tables and some calculations and a sheet with graphs to display our data.

Before we go to Amplitude and upload the document, we need to clear the data.

Go to the Report Data sheet and clear all the information leaving only the column headings (rows 1 and 2).

Go to the sheet with Pivot Tables, click on one of the tables to open the PivotTable Tools, click Analyze, then Refresh and Refresh All.

All the Pivot Tables should now be empty.

Save and close the document.

Find the report you originally got the data from and click on the name to edit the template.

Click Choose File and open the document you just saved.

Then into the Excel Worksheet Name box enter the name of the sheet which had the raw data on, in this case it was Report Data and will normally be this unless you have specifically changed it. Bear in mind this is case sensitive.

Scroll down and click Save.

Next time you need the report, run it as you normally would. Download the file and open in Excel.

Click Enable Editing in the top yellow bar.

If you click the Report Data sheet you will see the data has automatically saved here.

Go to the sheet with Pivot Tables, click on one of the tables to open the PivotTable Tools, click Analyze, then Refresh and Refresh All.

The Pivot Tables should all refresh with the new data.

Go to the graphs sheet and you will find they have all refreshed with the new data.

Troubleshooting: Pivot tables not refreshing properly

If the pivot tables do not fresh properly with the new data this is because either:

• The new data is causing the pivot tables to overlap – to solve this cut and paste the pivot table which is causing the problem to another space in the sheet and try refreshing again.
• The Report Data column headings have changed. This may have been caused by a system upgrade or a clinical change to the pathway. To fix this re-select the pivot table fields.

Filters:

The Excel Filtering Tool is a simple feature but is great if you only want to view patients with a certain criteria e.g. only those with a procedure form or only male patients.

To use the tool first select the entire row with the column headings in (usually row 2) by clicking the row number.

Click Sort & Filter and in the drop down select Filter.

You will then see small grey boxes at the bottom right of each heading.

Click the box of the column you’d like to filter (e.g. gender) and de-select any items you do not want to see (e.g. female).

Click OK and those items should hide, in this case leaving only male patients.

You can then filter further or reverse this process by clicking the grey box again and re-selecting the items.

PivotTables:

Pivot Tables:

The first step is to create your report template in Amplitude, run and download the data; we will call this the raw data. To find out how to do this see previous guides in this section.

Select all the data by clicking the small box in-between the column letter ‘A’ and the row number ‘1’.

Click Insert and then PivotTable.

A box will pop-up. You don’t need to change anything here, click OK.

You will then see a blank PivotTable on a new sheet.

From this point on you can customise the table as you wish using the data you have and add more PivotTables.

In this example we want to analyse our patients scores. First tick the box next to Pathway ID.

This has added the ‘Sum of Pathway ID’ to the table however we want the ‘Count of Pathway ID’ so we can count how many patients we have. To do this right-click ‘Sum of Pathway ID’, hover over ‘Summarize Values By‘ and click Count. This has now changed it to a count of our patients.

Click and drag VAS pain scores at each time interval into the PivotTable Values box.

Similar to before, right-click the ‘Sum of VAS Pain – Score – Baseline’, hover over ‘Summarize Values by’ and click Average.

This will now display our patients average Baseline VAS Pain Score. Repeat this for each time interval of the score.

Now we have the figures, we can graph the data.

Make sure a cell you are in is within the PivotTable. Click Insert and choose the graph type. Here we have chosen a simple bar chart.

A graph will then pop up.

However notice our rows and columns are the wrong way round. To fix this right click on the graph and click ‘Select Data…’.

Click ‘Switch Row/Column’.

Then click OK.

The graph is now fine to use as it is, however we want to add some data labels.

To do this right-click on the graph and and click ‘Add Data Labels‘.

The graph can be customised as you’d like, here we changed the Number of Patients bar to a different colour.

To further analyse the data we can use filters to see if certain variables effect our outcomes.

To do this first click on the PivotTable to open the ‘PivotTable Fields‘ box. Click and drag the variable (e.g. Hospital) into the ‘Filters‘ field.

You will then see the filter field above your PivotTable, you can repeat this process to add as many filters as you’d like.

Save time next time by uploading this file to Amplitude to use again. See Excel Template Uploads to find out how.

How to Run the Report:

First click on the bar chart icon to go to your Reports Dashboard.

Click ‘In-Built System Report Templates‘ and here you will see the Revalidation Report.

Click the green play button.

Choose a date range or to see all of your patients with procedures choose ‘Search across whole database’. If you choose a date range, bear in mind this works on pathway start date – not procedure date.

If you are running this report and currently data exchange from a pro one™ or pro enterprise™ account, check the ‘Show external patients in completed report’ box.

You can then choose to export as a .csv file or an .xlsx file.

Click Run Report.

Whilst the report is compiling, it will sit in ‘My Running Reports‘ with a spinning arrow. The time it takes to run depends on the amount of data you have.

Once completed it will move to ‘My Completed Reports’.

To view the report click the green download icon and acknowledge the privacy notice.

The report will then download and will be saved in your computers downloads folder for you to access.

Accessing and Using the Report:

Find and open the report.

Click enable editing.

The graphs and filters will then update to show all of your data.

The document will open on the filters tab. Here you can filter by any variable returned in the report, such as Approach and Procedure Type. If you select a filter option, all graphs will instantly update to only show the outcomes of patients with that variable present.

If you’d like to select multiple items on one filter, click the multi-select icon.

To clear the filter selections click the red cross.

If you wish to see the outcomes of all your patients, you don’t need to use any filters.

Click ‘Universal‘ to see the outcome scores which are used across all pathway types.

Click your specialty to see it’s specific outcome scores.

If you’d like to see your data in it’s basic format, you can click the ‘Raw Data’ tab.

Here, each row represents a pathway. The columns range from procedure form items to score values.

Please note: This report does not contain any patient identifiers.

To navigate back to the main page click any of the other tabs across the bottom.

How to Save as a PDF:

If you’d like to save any information as a PDF document, first make sure you are on the page you wish to save.

Click File at the top left-hand corner.

Go to ‘Save As’ and then ‘Browse‘ to find the location you wish to save the document in

Name the file something meaningful to you and then change the file type to PDF.

Click Save.

When you open the PDF file you should only see the information displayed on the chosen tab within the Revalidation Report.