KNOWLEDGE BASE

Dynamic Title Shows 'All' when No Data is in the View


Published: 17 Apr 2014
Last Modified Date: 24 Feb 2017

Issue

When using a calculated field in a dynamic title, and all of the data is filtered out of the view, the dynamic title might be displayed as "All".

Environment

Tableau Desktop

Resolution

Use one of the following workarounds:

Option 1

Use a dynamic title based on a parameter.

Step 1: Connect to Data

Open a new workbook and connect to your data source.

Step 2: Create a Parameter

  1. In the Data pane, click the caret at the top right of Dimensions and select Create Parameter.
  2. In the Create Parameter dialog box, name the parameter. In this example, the parameter is named "State Select".
  3. Under Data Type, select String.
  4. Under Allowable Values, select List.
  5. Click Set From Field and select the desired field.
  6. Add All to the list of values.

Step 3: Create a Calcuated Field for the Filter

  1. Go to Analysis > Create Calculated Field.
  2. In the Calculated Field dialog box, type a name for the field. In this example, the field is named "State Filter".
  3. Type the following into the Formula field:
    [State] = [State Select] or [State Select] = "All"
  4. Click OK.

Step 4: Create a Calculated Field for the Title

  1. Go to Analysis > Create Calculated Field.
  2. In the Calculated Field dialog box, type a name for the field. In this example, the field is named "Dynamic Title".
  3. Type the following into the Formula field:
    IF [State Select] = "All" THEN "Information for all Cities within the United States" ELSE "Information by City for " + ATTR([State])END
  4. Click OK.

Step 5: Create the View

  1. Drag State Filter to the Filters shelf.
  2. Select True and click OK.
  3. Right-click State Select in the Parameters pane and select Show Parameter Control.
  4. Drag Dynamic Title to Detail on the Marks card.
  5. Place City on the Rows shelf.
  6. Place Sales on the Columns shelf.
  7. Drag Sales to Text on the Marks card.
  8. Navigate to Worksheet > Show Title.
  9. Right-click on the title in the view and select Edit Title....
  10. Clear the current title and navigate to Insert > AGG(Dynamic Title).
  11. Click OK.

Option 2

Add a Size() calculated field to the Detail and Filter shelves that computes using the calculated field in the dynamic title. 

Option 3

In some situations (including when duplicating a dashboard, or when table calculations for the field are edited) the field used for the title will be appended with a number in parentheses. Removing this number may correct the behavior. Edit the title, removing the number after the field name, between the <> escape characters. For example:
  • Original Title:  Here is my title and a value: <AGG(Field Name) (3)>
  • Corrected Title:  Here is my title and a value: <AGG(Field Name)>

Cause

This behavior is related to a known issue that is currently under investigation.
Did this article resolve the issue?