Page History
To request access to Tableau, submit a ticket to the ONHRDB Service Desk.
| Expand | ||
|---|---|---|
| ||
|
Steps to Access the NEP & ONP Raw Data Report in Tableau
To run to run the NEP & ONP 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 right 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 A04 - ONP Raw Data Report:
- Select NEP ONP Raw Data Report
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 any sites you do not wish to include in the report.
Additional filters are available for the NEP/NSP Transactions and NEP/NSP Pack Transactions. These filter can be utilized to isolate and focus on specific sets of data within this tab.
NEP/NSP Transactions tab filters
Item Type:
- The item type refers to the specific category or classification under which items are grouped. This data can be utilized to isolate and focus on specific sets of information within this tab.
Item:
- The item dropdown refers to the specific item(s) being tracked.
NEP/NSP Pack Transactions tab filters
Item Type (Pack Transactions):
Item (Pack Transactions):
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 their preferred format for downloading a report. It is recommended to download this report as Excel Crosstab for optimal formatting .
If data extraction is needed, users can download in Excel or CSV format by selecting Crosstab from the report download menu.
as this report is aggregate data.
To download your report, click on the download button 
at the top right of the screen.
Select the format you prefer. Once the format is selected click
Once the format Follow these steps if one of the following formats is selected click Download:
Crosstab
:
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.
Only the Client Info tab will be downloaded.
To download to PDF, PDF must be selected. The whole report will be downloaded to PDF.
Each page will display each tab of NEP ONP Raw Data Report
For more details on the Harm Reduction Outreach report calculations, please click here
