KNOWLEDGE BASE

Asterisks Display in Tooltips


Published: 03 May 2013
Last Modified Date: 25 Jul 2018

Issue

When hovering over a mark in a view, the tooltip shows asterisks (*) for corresponding fields.

Environment

Tableau Desktop

Resolution

Option 1

Add the dimensions of the field you want to display to the Details Marks card.

Option 2

Use the dimensions elsewhere in the view to ensure that the marks are at the same level of detail.

Option 3

The following instructions uses the sample data set Superstore to create a list of containers for each department, and can be reviewed in the attached workbook located on the right side of this page.

Step 1: Create the Calculations

  1. Create a calculated field with a name like "Filtered Containers Feeder" with a calculation similar to the following:
    IF FIRST()= 0
    THEN MIN([Container])
    ELSEIF MIN([Container]) != LOOKUP( MIN([Container]), -1 )
    THEN PREVIOUS_VALUE("") + ", " + MIN([Container])
    ELSE PREVIOUS_VALUE("")
    END
  2. Create a calculated field with a name like "Filtered Containers for Tooltip" with a calculation similar to the following:
    IF LAST() = 0
    THEN [Filtered Containers Feeder]
    END


    Edit calculated fields in the attached workbook for additional notes about how these calculations work.

Step 2: Create the View

  1. Drag [Department] to the Rows shelf
  2. Drag [Sales] to the Columns shelf
  3. Drag [Container] to Color on the marks card
    Note: [Container] must be included in the view for the calculations to work correctly. If the final view should not include the dimension being listed in the tooltip, see the "Adv Option 1" tab for additional instructions
  4. Drag [Filtered Containers for Tooltip] to Tooltip on the marks card
  5. Right-click [Filtered Containers for Tooltip] on Tooltip and select Compute Using > Container
Note: If additional dimensions are added to the view, then it may be necessary to update the Compute Using setting. For detailed explanation of how to control the output of a table function with Compute Using settings, please see Addressing and Partitioning.

Cause

Dimensions are added to the tooltip using the ATTR aggregation. The asterisk is actually a visual indicator of a special type of Null value that occurs when there are multiple members that apply to the mark.

Additional Information

When using data blending, asterisks are typically displayed when there are more than one matching member in the secondary dimension for each mark.

To voice your support for the inclusion of this enhancement in a future product release, add your vote to the following Community Idea: List all instances of a dimension or measure
Did this article resolve the issue?