KNOWLEDGE BASE

Unable to Use Groups in Calculated Fields


Published: 18 Jul 2014
Last Modified Date: 02 Jun 2016

Issue

Unable to use groups in calculated fields.

Environment

Tableau Desktop

Resolution

Use one of the following workarounds.

Option 1

Create the group using a calculated field. For more information, see Creating Groups Using Calculated Fields in the Tableau Knowledge Base.

Option 2

Create a set from the group, and then use the set in the calculated field.
  1. In the Data pane, right-click the group, and then select Create Set.
  2. In the Create Set dialog box, do the following, and then click OK:
  • For Name, enter a name.
  • On the General tab, select the group.

Cause

The ability to use a group in a calculated field is not currently available in Tableau Desktop.

Additional Information

Calculated fields cannot be added to existing ad-hoc Groups.

To voice your support for the inclusion of this feature in a future product release, add your vote to the following Community Idea: Use ‘Groups’ in Calculated fields.
Did this article resolve the issue?