TABLE OF CONTENTS
This article provides an overview of navigating DIR interactive reports developed with Tableau software. The CT Standardardized Dose Index Report is used to provide examples of how you can query, filter and navigate data to identify patterns and gain performance insights.
The reports contain multiple tabs called dashboards that appear across the top as shown in the screenshot below. Each dashboard has three help features in the upper left corner. Select:
The Help link to view a report overlay that describes the report functionality
The info icon (blue circle) to gain insight into the report
The Read about this report to read a Knowledge Base article that has more report details.
Filters and Parameters
Interactive reports use filters and parameters to help users analyze performance data.
Filters provide choices for selecting criteria to restrict what data are shown. For example, the Facility ID filter in the Exam Search dashboard shown 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.
Scanner Aggregation Level: Determines whether to aggregate scanner data in the chart by device, model, or manufacturer.
Click anywhere on a filter to display a list of possible 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.
For filters with lots of values, a search bar appears for wildcard searches. For example, typing AB in the filter example shown at the right 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.
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 the 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 are 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, and registry statistics table. Each of these may be downloaded. Click just above a chart or table, then click the Download button and select Crosstab.