Skip to main content

Outcomes Framework - Download Results

When you’ve spent sufficient time playing with the settings on the metric and you understand the breakdowns, you can download an Excel spreadsheet with all the data based on your configurations.

Please note:​

Some of the analysis done by the Mirah system is too complicated to easily represent in Microsoft Excel downloads. If you select an option which is not supported, the Download this data in Excel format will be disabled. Currently, we do not support downloads for Efficiency metrics, only for Effectiveness metrics.

There are two ways of downloading data.​

1). On either the Create or Edit Metric screen or Metric Details page, press Download this data in Excel format in the Statistics section.

The screenshot displays a statistics page within the Mirah Collaborative Care platform, specifically focusing on the Outcomes Framework for Reporting & Analytics. The page shows a line graph illustrating the number of rows that met the Inclusion and Success Criteria by treatment episode start date, with dates ranging from 12/1/2023 to 5/1/2024. Below the graph, numerical data is presented: 80 rows treated, 13 in the time window, 13 included, and 7 successful, with a success rate of 53.8%. At the bottom left corner, there is a button labeled 'Download this data in Excel format,' which allows users to export the displayed data for further analysis.

2). On the Metric Dashboard, click the download icon pictured below.

The screenshot displays the 'Remission- Symptoms and Functioning Youth Report (SFSS Youth)' which provides insights into the percentage of patients whose symptoms went into remission after meeting one inclusion criteria following three months of treatment. The report includes a line graph titled 'Helping Hands' that shows data points over time, specifically from December 1, 2023, to May 1, 2024. The graph illustrates the percentage of patients, with a notable dip and rise in the data. On the right side, the report highlights a key metric of 53.8%, representing the remission rate, along with detailed statistics: 7 Successful, 13 Included, 13 Measured, and 80 Treated. At the top right corner, there is a download button encircled in red, allowing users to download the report, and a settings icon for additional options.

Confirming Download​

Once you press the respective download button, it will be asked to give the spreadsheet a name.

The 'Download Data' screen in Mirah Collaborative Care's Reporting & Analytics feature allows users to download metrics as an Excel file. The screen prompts the user to enter a name for the file in a text input field labeled 'Give the file a name'. This input is necessary to proceed with the download. Below the input field, there is a 'Begin export' button, which is currently disabled, indicating that the user must first provide a file name to enable it. The purpose of this screen is to facilitate the export of data for further analysis, allowing users to modify criteria within the Excel file. The close button is located at the top right corner of the dialog box.

Once you give it a name and press Begin export, the file will begin generating. Once complete, you will be given a link to download the excel file.

The spreadsheet download doesn’t contain any PHI, so it can be freely shared via email or other methods of communication. Customers often use this download to share the results with executive leadership and those who do not have access to the Mirah tool. See photo below of the dashboard tab in the Excel download.

The screenshot displays a spreadsheet from Mirah Collaborative Care, specifically focusing on the 'Treatment Response - Depression (PHQ-9)' report. The top of the screen includes Excel's toolbar with options like 'Get Data (Power Query)', 'From Picture', 'Refresh All', and 'Queries & Connections', which are used for data management and updates. Below the toolbar, the spreadsheet is titled 'Treatment Response - Depression (PHQ-9)', with details such as 'Date Range' from 2023-06-29 to 2023-12-29, 'Scale' as Patient Health Questionnaire-9 (PHQ-9), and 'Entity' as Helping Hands. The 'Overall Results' section on the right provides metrics: 'With Measurement In Time Period' is 256, 'Meeting Inclusion Criteria' is 141, 'Meeting Success Criteria' is 60, and '% Meeting Success Criteria' is 43%. Instructions are provided below these details, explaining the purpose of the download and how the data can be used or modified.

More instructions on how to use the Excel export are included in the spreadsheet itself.

If you want to continue to monitor the metric, make sure to save it. Instructions on how to do this are at the bottom of the pages for Editing a Metric or Creating a Metric, depending on your circumstance.