To make a workbook available in Tableau Online, you need to publish it from Tableau Desktop to Tableau Online. You can do this by selecting Publish Workbook from the Server menu, signing in to your Tableau Online account, choosing a project and a name for your workbook, and clicking Publish. This will upload your workbook and its data sources to Tableau Online, where you can view, edit, and share it with others. References:

Tableau Certified Data Analyst Exam Prep Guide , page 10, section “Publishing and Scheduling Data Refreshes”

Tableau Help: Publish a Workbook

we need to create a quick table calculation that shows the percent of total sales for each category and sub-category. To do this, we can follow these steps:

Drag Category to Columns and Sub-Category to Rows.

Drag Sales to Text on the Marks card.

Right-click Sales on the Marks card and select Quick Table Calculation > Percent of Total.

Right-click Sales on the Marks card again and select Compute Using > Category.

This will create a quick table calculation that shows the percent of total sales for each sub-category within each category. The visualization will look like this:

The LAST() function in Tableau returns the number of rows from the current row to the last row in the partition. When you compute using ' Order Date ' , it will change the partitioning of the calculation. If ' Consumer ' in ' 2018 ' is the last row in its partition when computed by ' Order Date ' , then LAST() will return 0 for that cell.

The LAST() function in Tableau is a table calculation that returns the number of rows from the current row to the last row in the partition. The value of LAST() is 0 for the last row, increases by 1 for each row above the last row, and can be negative for rows below the current row if there are such rows in the partition.

In the provided visualization, LAST() is set to compute using Table (across). Changing the compute mode to use " Order Date " will adjust the partitioning of the data upon which the LAST() function is calculated. Since " Order Date " is likely to be a unique value per row (assuming each order has a unique date), each row becomes its own partition.

For the Consumer segment of the year 2018, if " Order Date " is unique for each row, then the last row in each partition (in this case, each individual row) will have a LAST() value of 0 because there are no other rows in the partition - it ' s the last row of its own partition.

Therefore, when you change the compute mode of LAST() to use " Order Date " , each cell under the Consumer segment for the year 2018 will have the LAST() value of 0, because each order date creates a partition of one, making every row the last in its partition.

A reference line is used in Tableau to display a line at a constant value or a computed value such as an average, median, minimum, or maximum in a bar chart. In this case, adding a reference line would allow you to show the median, upper quartile, and lower quartile, which corresponds to the changes shown in the bar chart.