Data Panel

For Everyone

At a glance

The Data panel is where you apply settings to show the data in your Data Bite, Linear Gauge, and Waffle charts.

Where to Use

Visualization Types

This panel displays for Data Bites, Linear Gauges, and Waffle Charts.

Common Fields

(Numerator) Data Column: This drop-down allows you to select the column that has the numbers you want to calculate. For Gauge and Waffle charts, this field sets the numerator.

(Numerator) Data Function: Select the mathematical function to apply to the numbers you’ve targeted. This calculation occurs natively within the module itself. Options are Count, Max, Mean (Average), Median, Min, Mode, Range, Sum. For Gauge and Waffle charts, this field sets the function of the numerator.

Prefix: Add characters before the data, such as $.

Suffix: Add characters after the data, such as %.

Round: Set the number of places to round the data to.

Add Filter: Click the button to add a filter to your visualization. This filter is static.

  • Column: Select the column to filter on.
  • Column Value: Select the value to filter on.

Data Bite Specific Fields

Add Commas: Add commas to numbers greater than 3 digits.

Ignore Zeros: Ignore any zeros in the dataset when calculating the number. For example, you have 10 data points and 3 of them are zero. You want to display the Count, so you check this box to have the Count display 7.

Gauge and Waffle Specific Fields

Numerator Data Conditional: Column selections are generated by the headers in your data. Select the data column, the qualifier, and the value you want to reference.

Select from Data: Check box to calculate the denominator from the data rather than a set number.

(Number): For denominators not selected from the data. Defaults to 100, set the denominator to a static number.

Denominator - Data Column: This drop-down allows you to select the column that has the numbers you want to calculate.

Denominator - Data Function: Select the mathematical function to apply to the numbers you’ve targeted. This calculation occurs natively within the module itself. Options are Count, Max, Mean (Average), Median, Min, Mode, Range, Sum.

Value Descriptor: Gauge chart only. Customize the words that follow the data. Defaults to "out of".

Show Percentage: Gauge chart only. Check to put a percent sign after the data.

Show Denominator: Gauge chart only. Check to show the number of the denominator following the value descriptor.

TP5 Style Trend Indicators

  • Trend Mode: Available for TP5 Data Bite, TP5 Waffle, and TP5 Gauge. Turn trend indicators off, or choose Categorical or Numeric mode.
  • Trend Column (Categorical): In Categorical mode, select the data column used to determine the trend direction. In categorical mode, arrows appear only when filters resolve to exactly one row. For Data Bite using the Pass Through data function, the first matching row is used.
  • Trend Column (Numeric): In Numeric mode for TP5 Data Bite, select the column that contains past data for the metric. It uses the same function selected from the Data Function dropdown.
  • Trend Numerator Column: In Numeric mode for TP5 Waffle and TP5 Gauge, select the column that contains past numerator data for the metric.
  • Trend Mapping: In Categorical mode, map each source value to a trend arrow type.
  • Add Trend Mapping: Add an additional custom source value and arrow mapping.
  • Threshold: In Numeric mode, set the minimum difference required before an up or down indicator appears. Numeric mode supports Sum, Mean (Average), Median, Min, and Max.
  • Up Label: Set the text shown when the trend is increasing.
  • Down Label: Set the text shown when the trend is decreasing.
  • Show indicator for no change: In Numeric mode, show a no-change indicator when values do not move beyond the threshold.
  • No Change Label: Set the text shown for no-change results.
  • Trend description: Add supporting context text shown with the trend indicator.
Print
Content Source:
Office of Communications