Page History
To request access to Tableau, submit a ticket to the ONHRDB Service Desk.
| Expand | ||
|---|---|---|
| ||
|
Steps to Access the CTS Medical Emergencies Raw Data Report in Tableau
To run the CTS Medical Emergencies raw data report log into Tableau (link).
Navigate to the "Explore" Section:
- You can access "Explore" in two ways:
- From the Home screen.
- From the Menu Panel on the left side of the screen.
| Info |
|---|
| Users can also access reports from Favorites, Recents, and Recommendations once a report has been run or favorited. |
Access the ONHRDB Folder:
- Click on the ONHRDB Folder
Open the Reports Folder:
- Click on ONHRDB Agency Reports to view all available reports.
Choose the report you are trying to run:
- Select the A01 - Harm Reduction Outreach A06 - CTS Medical Emergencies Raw Report:
- Select HROP CTS Medical Emergencies Raw Report Dashboard
Setting Filters for Your Report
Filters allow you to customize your report to display only the most relevant data. Key filters include:
Date Filter:
- Enter dates manually or use the calendar to select the start and end dates.
PHU Filter:
Select your organization's Public Health Unit (this field will auto-populate).
Agency Filter:
- Choose any associated agencies linked with your PHU, if applicable.
Site Filter:
- View all sites associated with your organization in NEO. Deselect Users can deselect any sites you do not wish to include in the report.
Additional Filters for Your Report
Additional filters are available at the top of your report to help manage and adjust or reset filters as needed:
Export/Download a Report
Users can select choose their preferred format for downloading a the report. It For optimal formatting, it is recommended to download this report as a PDF for optimal formatting.
To download , users can download in Excel or CSV format by selecting Crosstab from the report download menu.
Crosstab since it contains aggregate data.
To download your report, click on the download button button 
at the top right of the screen.
Select the format you prefer. Once the format is selected a new window will appear with further customization options to download the report.
Once the format is selected click Download:
Crosstab
Follow these steps if one of the following formats is selected:
Crosstab 
To download to Excel or CSV Crosstab must be selected. The report must be downloaded by sheet, the user must be in the sheet that they want to download.
| Info |
|---|
Only the CTS Medical Emergencies Data sheet should be selected. |
To open the downloaded Excel file, locate it in your system's default download folder or the location where it was saved, and double-click it. Ensure you have spreadsheet software, such as Microsoft Excel or Google Sheets, installed to view the file.
PDF 
To download the report as a PDF, select the PDF option. The entire report will be included in the download.
To open the downloaded PDF, locate the file in your system's default download folder or the location where it was saved, and double-click it. Ensure you have a PDF reader, such as Adobe Acrobat Reader, installed to view the file.
