CODEWITHSUNDEEP
tableau-api
tmnsnmt
tmnsnmt

Reputation: 95

Creating a combined option in dimension

I have a dimension which is simply a list of user groups such as the below:

User Type

I am currently visualising these as an individual pie for each user type with the numerical value shown in the middle which is their answer to a question from another measure. However, I'd like to create a fourth type which is 'All users' so that I have four pies showing at once: All Users, Type A, Type B and Type C.

Is this possible? Would it be a calculated field? I have tried groups but can't get it to work.

Any help much appreciated!

Upvotes: 1

Views: 28

Answers (1)

Alex Blakemore
Alex Blakemore

Reputation: 11896

Assuming for the moment that you have User Type on the Columns shelf, you can simply choose Totals->Show Row Grand Totals from the Analysis menu.

An alternate approach is to display two worksheets on the same dashboard. To do that, simply duplicate your worksheet. Remove User Type from the view in the new worksheet. And then place both views next to each other on a dashboard, possibly in a layout container to keep them lined up nicely. Format a bit to remove the titles and outside borders and they can look like one unit.

Remember what a dimension does. It partitions the data rows according to the value of the dimension field, assigning each data row to exactly one partition - exactly like a Group By clause does in SQL. So a data record can’t be associated with more than one member of a dimension. Totals behave differently, which is why they address your use case.

Upvotes: 1

Related Questions