KNOWLEDGE BASE

Unable to View All Data for a Single Calculated Value


Published: 13 Oct 2017
Last Modified Date: 17 Oct 2017

Issue

You are unable to view all data for a single calculated value.

Environment

  • Tableau Server 10.1.0
  • Tableau Desktop
  • Windows 10
  • MS SQL Server

Resolution

To display the view all data option when selecting a single calculated value, the fieldname must be used and the placeholder value must be hidden:
  1. In Tableau Desktop, drag the dimension to the columns shelf. Click the "Text" shelf button and align the value text to the top.
  2. Drag to minimize or hide the second row.
  3. To format the borders in Tableau Desktop use the Format borders pane > Sheet tab> bto adjust the pane color and width.
  4. Re-publish the workbook to Tableau Server

Cause

The calculated field value is aggregated and will not have the option to drill down.
Did this article resolve the issue?