DIR Interactive Reports allow you to query, filter and navigate data to identify patterns and gain insights. This guide provides aoverview for navigating the reports developed with Tableau software.
You can also watch the video demos on Working with Interactive Reports, including how to download data and work with date filters.
Most reports, such as the Standardized Dose Index Report, contain multiple tabs across the top.
Filters and Parameters
Interactive reports use filters and parameters to help users analyze reports. Although they appear similar, they provide different functionality.
Filters provide choices for selecting criteria to restrict what data are shown in a report using values directly from the dataset. For example, the Facility ID filter in the Exam Search report above lists all facilities available to the user by directly querying the dataset.
Parameters are inputs that change what a user sees or how data is computed in the report. For example, the Boxplot by Scanner report uses several parameters, including
DIR Measure: Selects which Dose Index type to chart. The maximum CTDIvol value across all scans (CTDIvol Max Across Scans), the sum total Dose Length Product for the exam (DLP Total for Exam), etc.
Query by: Determines whether the RPID / Study Description filter displays standardized RPID exam names or the facility’s own Study Descriptions.
Registry Statistics: Selects whether to display the DIR Median, DIR 75th percentile, or both.
Scanner Aggregation Level: Determines whether to aggregate scanner data in the chart by device, model, or manufacturer.
Most reports do not display any data until all filters have selected at least one value. Some filters are set to None by default and must be selected by the user before data can be retrieved.
The report title page indicates the minimum filter criteria to be set in order to retrieve data upon first opening a report. The reports available in the Standardized Dose Index Report require at least one Facility ID and one RPID or Study Description to be selected. The selected values are shown in blue as part of the report title. If either field is set to None, then nothing appears in the report.
Click anywhere on a filter to select values. Filters that allow more than one selection have an Apply button so that you can select multiple values and control when they are applied to the report. The Apply button is greyed out until at least one value is selected.
Click on the desired values, then click the Apply button to apply the changes, and then click anywhere on the report to close the filter selection window. Note that you may need to select values for other filters before any data appears in the report.
For filters with lots of values, a search bar appears for wildcard searches. For example, typing AB in the filter below quickly restricts the filter to only RPIDs with the letters AB appearing anywhere in the description. Searches are not case-sensitive. The values in some filters are dynamic and are determined by the values selected in other filters. The Exam Search report shows only those RPID/Study values available for exams that meet the other filter criteria.
Choosing Image or PDF creates a .png or PDF file of the current screen. These options capture only what is visible on screen, i.e. what you can see without scrolling.
Data creates a .csv file of the rows meeting the current filter criteria. The Summary tab includes the fields displayed on screen, and the Full Data tab includes additional fields that meet filter criteria but may not be displayed in the report.
Crosstab creates a .csv in a cross tabular format. This is the best format to use when trying to download data into a spreadsheet, such as Excel. If the Crosstab options greyed out, click on the blank space just above the chart or table you want to download. For example, the Scatterplot Over Time report has three data sections: scatterplot, scanner statistics table, registry statistics table. Each of these may be downloaded. Click just above a chart or table, then click the Download button and select Crosstab.
Note: You can also watch a video to see how to download data to Excel.
Highlighting and Details
With some interactive reports, you can highlight segments of data and hover over data points for additional information. For example, positioning the cursor over a single data point in the Scatterplot Over Time report provides detailed data about a particular exam. Clicking on the data point highlights similar exams. All exams taken with the same scanner are highlighted. To undo highlighting, click on the data point a second time.
For tables, the highlighting feature works when clicking on a data value in the table. Hovering over the value 3.56 in the table, below, brings up more details for the exam.
Reports with legends also allow you to highlight a specific item by clicking on the legend. By clicking on a single scanner in the Scatterplot report data points for all other scanners are highlighted.
You can also apply your own filter to exclude data when interacting with a chart legend, marks on a chart, or data in a table. This can be particularly useful if a chart or table has lots of data and you want to focus on specific items. The scatterplot below has more than 700 marks for three facilities and four scanners for a single study and age group. Using the facility legend, we can highlight data for a single facility. However, there are still many data points and it appears there are multiple scanners for this facility, as indicated by the different shapes, but it is difficult to make out the patterns.
We can also highlight the chart by different scanners by clicking on one from the legend, rather than highlighting by facility, but that would show the data for the selected scanner across all facilities. Alternatively, we can click on the facility in the legend and then click on Keep Only to keep only the marks for the highlighted facility (selecting Excludewould exclude all marks for that facility and keep the remaining facilities.)
The chart has now been filtered to show only the 438 exams for that facility. We can now highlight each scanner, using the Scanner legend, to see the patterns more clearly. To undo the filter, click on the Undo button, located in the bottom left corner of the screen.