Dynamic Footnotes

At a glance

Dynamic footnotes can be added to a dashboard element so they change as the filtered data changes.

Usage

It is important that your footnote data file is formatted correctly. You will need columns for the symbol, the text, and the order. Additionally, you need to ensure that you have a column that matches the filter values exactly. This includes capitalization and spacing.

Example Dashboard with Dynamic Footnotes

This dashboard has footnotes that change based on the dropdown selection.

Sample Data: Dynamic Footnotes Example - Table, Dynamic Footnotes Example - Footnotes

Visualization Type

  • Dashboard
Imported Files
  • valid-data-table.csv
  • valid-data-table-footnotes.csv

Row 1

  • Table inserted
Table: Data Format

  • valid-data-table.csv
  • Vertical
  • Multiple Series: No
Table: Filters Panel
  • Filter Behavior: Filter Change
  • Add Filter
  • Filter Style: Dropdown
  • Label: Location
  • Filter Order: Ascending Alphanumeric
  • Check Show Filter and Filter Footnotes
Table: Data Table Panel

  • Exclude Columns: URL
  • Check Collapsible, Expanded by Default, Show Download CSV Link, and Show Link Below Table

Table: Footnotes Panel

  • Footnote Dataset: Valid-Data-Table-Footnotes.Csv
  • Footnote Symbol Column: SymbolCol
  • Footnote Text Column: TextCol
  • Footnote Order Column: OrderCol

Print
Content Source:
Office of Communications