Data Tools FAQ
This page provides helpful hints and answers to commonly asked questions about using the Data Tools. For FAQs related to specific tools, check out the following links:
- What software was used to build the Data tools?
- How do I select a group of options within a multi-select filter dropdown?
- How do I select all check box options within a multi-select filter dropdown?
- What do the parentheses around a filter value mean?
- What does it mean when a filter shows "(Multiple values)"?
- How can I search for a specific value in the dropdown options? For example, you are interested in measures related to HIV.
- Why can't I see a map on the HCUPnet Community Inpatient data tools?
- How do I correct data table column line breaks?
Development and maintenance of the AHRQ Data Tools use the Tableau platform.
Select your first item, checkbox, hold the SHIFT key, and select the last option in the group of items you wish to select.
Figure 1: Example screenshot from HCUPnet National Inpatient Diagnoses and Procedures data tool
Select the check box with the “(All)” to select all options available under the filter dropdown. This option is only available for select dropdowns.
Figure 2: Example screenshot from HCUPnet National Inpatient Diagnoses and Procedures data tool
Parentheses around a filter value mean that the selected value is not applicable based on prior selections. When this occurs, reselect filter values from top to bottom.
For example, in the Medical Expenditure Panel Survey (MEPS) Household Component (HC) Accessibility and Quality of Care data tool, the expected results display upon selecting the Diabetes Care Measures, which then filters the Diabetes Care Measure Level selections. When you update the top-level filter, Diabetes Care Measures, the prior selection ("Never had an eye exam" in the below example) selection is no longer applicable; the system will add parenthesis around the lower-level filter selection, indicating this is no longer applicable.
Figure 3: Example screenshot from MEPS-HC Accessibility and Quality of Care data tool
When you select more than one option in a multiple-selection filter, the filter will display "Multiple values".
Figure 4: Example screenshot of a filter with multiple values selected
Using the "Measure" filter, select drop-down filter options and type text within the top white box space; for example, the text “HIV”, will limit filter options to only show options with HIV in the description. This technique can be used on any filter on any data tool dashboard to limit available filter options.
Figure 5: Example screenshot from National Healthcare Quality and Disparties Reports Data Query data tool
If you change selections for filters, the resulting map display area will display as blank in some instances. Please select the Home button to re-set the map.
Figure 6: Screenshot from the HCUPnet Community Quality Indicators data tool showing a selection of the Home button
Figure 7. The image depicts line breaks within a dashboard data table.
Steps: Scale the display resolution to the native setting and turn off the feature for auto-scaling. All figures and steps below are using the Windows 10 Pro operating system.
1. Navigate to the Display settings by right-clicking on your Windows background and selecting "Display settings".
2. Set "Scale and layout" and set the scale to 100%.
3. Select "Advanced scale settings".
4. Within "Advanced scaling settings", turn the feature to "Off" under "Fix scaling for apps".
Figure 8. The image shows Windows Display settings options available.
Figure 9. The image shows the "Advanced scaling settings" window.