Child pages
  • Agency Submission Tracking Dashboard
Skip to end of metadata
Go to start of metadata




Introduction

The goal of the Agency Submissions Tracking Dashboard is to give State EMS officials a way to view submissions to the national repository over time, by Agency and Software Vendor, so that they can identify any changes in submissions over time.

Global Inclusion Criteria

The global inclusion criteria defines the minimum characteristics each event record must meet in order for it to be included in this dashboard. For details on each element, its code, and range of values see the NEMSIS Version 3.4 Data Dictionary.

All PCRs submitted to the national repository with a Unit Notified by Dispatch Date/Time (eTimes.03) of January 1, 2017 to present are included in this dashboard. Data in this dashboard can be filtered on Unit Notified by Dispatch DateSoftware Package (eRecord.02 + eRecord.03), Software Version (eRecord.04), EMS Agency Unique ID (dAgency.01), and Submitting State (internal/federal users only).

Elements of the Dashboard

This dashboard is comprised of two visualizations, a trend line and a table.

PCR Submissions Graph

This line chart is designed to show all submissions originating from the selected state over time, identifying any weeks where they appears to be a drop in submissions.

By default, this graph shows one data point for each week, with the line color representing any signification drop in PCRs from the previous data point. You can change the time period displayed on the graph by using the "Week of Unit Notified by Dispatch Date" slider. You can change the date scale to years, months, or days by using the plus and minus buttons that appear when you hover over the date axis:

When you hover over individual data points on the line graph, a tooltip will appear with a date, PCR count, and submission analysis (consistent, or a drop in records).

PCR Submissions Table

This table is designed to give further details on specific PCRs counts and trends for individual agencies in a selected state. Data in this table is shown by month, for each month since January 2017. You can use the scroll bars along the bottom and side of the table to see all rows and columns. Like the submissions graph, you can use the data slider at the top of the dashboard to adjust what data you see, and you can use the plus and minus buttons that appear in the column headers to change the date scale to years, weeks, or days.

Each cell in this table shows both the count of PCRs for the given month as well as the percent change from the previous month. Entries are colorized to show significant drops in submission from the prior month. By default, the table is sorted to show agencies in order of most submissions over the selected time period. The sort icon at the top of the EMS Agency Number column can be used to sort the table alphabetically, or smallest to largest by PCR count.

To use the PCR submissions table to filter the line graph, simply click on any agency listed in the table, and the PCR Submissions Graph will adjust to show only that agency's submissions by week. You can exit this filter by clicking the agency number on the table again. You can filter to multiple agencies by holding down the CTRL key and clicking the agencies you wish to view on the line chart.

This table also features a filter to remove agencies with very few submissions from the view. By default this filter is set to 50, i.e. any agency with less than 50 PCRs submitted over the time period will be excluded from the table. To change this filter, click the text box, and type in the desired minimum number PCRs to show. Please note that this filter cannot be set to zero or a negative number, this dashboard can only show agencies with at least one PCR submitted. For information on agencies the national registry has no PCRs for, please see the Submission Dashboard, on the state reports page of the NEMSIS website.



Tableau Toolbar

All Tableau dashboards share the same toolbar at the bottom of the view. Note that while most dashboards will have the same selections, some items may differ based on user permissions.

Undo, Redo, Revert, Refresh and Pause

These selections are found on the left side of the Tableau toolbar and can be used to help navigate the dashboard.

 

Undo will remove the last selection made, if you have used undo to remove a selection, you can then use redo to return to that selection. Revert returns the dashboard to its original view. Refresh will reload the data on the dashboard subject to any selections made. Pause will stop the dashboard from refreshing as you make selections.

As an example, if you want to make a set of complete selections in a dashboard’s filters, you could use these buttons to speed up the process. Normally every time a change is made, the dashboard will refresh. If you select “Pause” however, the dashboard will remain the same no matter how many selections you make. Once you have made all your selections, you can select “Refresh” to reload the dashboard based on those selections.

Subscribe, Custom Views, Edit, Share, and Download

These selections are found on the right side of the Tableau toolbar and can be used to interact with the dashboard in external ways.

 

The Subscribe button allows users to subscribe to a daily or weekly email that will show a static image of the dashboard as well as a link to the view.

You can select either a particular view (tab) or all the views (tabs) available in the dashboard. Under “Email Subscriptions” you can choose the frequency of emails and in “Subject Line” you can assign the subject for the emails. As a default, the subscription will be assigned to the email address associated with your NEMSIS account.

Custom Views allows users to save any particular set of filters or selections for quick access later. A user can create their view and then name it and save it either for their own personal use or use by anyone with access to this dashboard. Previously saved views will appear in the custom views tab.

Edit will open the dashboard in the web editor for Tableau. Note that this option is not available on all dashboards and will require some knowledge of how to use Tableau to build and edit dashboards.

Share will provide a couple of options for sharing the dashboard with others; specifically an embed code and a regular HTML link. While you can use the link to share the dashboard with others, please keep in mind that many of the NEMSIS dashboards will require a username and password so only those with credentials will be able to access them.

The last option is Download. Clicking on the download button opens up several options to download either the workbook, the data within it, or a static image of the view.

Selecting any one of these file types will produce a download of the requested file. Remember that not all options will be available for all dashboards and views.

Contact Info

Any questions, comments, concerns or suggestions with regard to this or other reports made available by the NEMSIS TAC, please contact us or leave a comment below!

Contact information is also available on our website.

Kevin White, BS
University of Utah School of Medicine
NEMSIS Technical Assistance Center
Phone: (801) 213-3408
Fax: (801) 581-8686
Email: kevin.white@hsc.utah.edu
Laurel Baeder, BA, MStat
University of Utah School of Medicine
NEMSIS Technical Assistance Center
Phone: (801) 587-7367
Fax: (801) 581-8686
Email: laurel.baeder@hsc.utah.edu





  • No labels
Write a comment…