Lift a chestnut! Tableau Trise (132): Data under data with parameter operation
published: 2021-06-11 17:34

We share the over-set operation to achieve the data of the tree map. In fact, for the Tableau users of 2019.2 and above, the following new feature parameters can be used to implement the following data in the chart.

TIPS: The set and parameters can be drilled. However, from the concept, the set and data sources are closely related, it will be updated with the update of the data source; the parameters are independent of the data source, which is the value introduced by artificial, will not update with the data source, so The application of the parameters is relatively flexible.

As the cylindrical chart, the mouse click on the column of any major class, you can immediately drop the corresponding subcategory.

How do you implement it? Today we will share the method,

The Tableau tricks we have to share with you this issue are: Use the parameter operation to implement the drill.

For the convenience of learning, chestnuts use Tableau to own the "example-supermarket" data source. After mastering the chestnut method, the data powder can try to use its own data.

Specific steps are as follows:

1. Create a bar chart

Open Tableau Desktop, connect "Example - Supermarket" data source, create a new worksheet.

Drag and drop the dimension "Category" to drag and drop the metric "Sales" to the column, and then drag and drop the dimension "Category" into the color of the "Tag" card. The following column chart appears in the working table view.

2, create parameters

In the "Data" pane, right click on the dimension "Category", select "Create" - "Parameters" in the drop-down menu. In the pop-up dialog box, name the parameter: Category parameters, select the data type as: string.

3, create a calculation field

Right-click on the "Data" pane, select "Create" - "Calculate Field" in the drop-down menu. In the pop-up dialog box, the calculation is named: subcategory (), type function:

IF [Category Parameters] = [Category] THEN [Subcategory] Else '' End

Then, the created calculation field "subcategory ()" also drags and dropped.


4, set parameter operation

Below, you need to set the parameter operation. Click the Top Menu Taba, select Operation. In the "Operation" dialog box that pops up, select Add Action.


Then, in the "Edit Parameter Action" dialog box that pops up, this action is named: parameter 1, select the source worksheet as: Worksheet 1, select the target parameter: Category parameters, select the field as: Category.

This completes the settings of the parameter operation. At this point, the chart can be drilled:

l  When all do not choose, there is a sales situation of all kinds of sales;

l  When you click on a category, you will display the subcategory sales of the selected category.

This issue of Tableau skills, have you get? Try it quickly!