Create a Parameter that shows the CountD (# of users) per Dimension category

Question

Hi Esteemed Tutors! Thanks very much in advance for you help.

I have built a Tableau Sheet with the CountD of users by a dimension category.

Now, I would like to use that sheet on a dashboard to create a small automatically updating box that show the # of Users, when a specific category is selected.

Can you tell me the formula for the calculated field and how to set up the parameter? Everything I am finding online gives instructions for a condition (i.e. top 10). I would like to show all the users in a category via parameter, so that it will work across multiple sheets in a dashboard.

Many thanks!

Answer 1

Hello!

The first step is to create your parameter. Select string as the data type and use a list as the allowable values. Use the drop-down for selecting field values to the right of the list and select the dimension containing your categories and save it as Categories Parameter.

Next is creating a new calculated field containing the following formula (Assuming your dimension is named Categories):

[Categories] = [Categories Parameter]

Save your calculated field as Categories Filter and drag it to the filters pane. Select True as the value to keep.

From there you could click the drop-down menu on thr filter and specify any/all worksheets you'd like to apply it to!