__________ function rounds a number to the nearest integer of equal or lesser value.
Connect to the "Global Superstore" data source and use the Orders table. Create a box-plots to show the sales distribution for each ship mode. Which of the following ship modes have the same median?
Drop the Sales to the Rows and disaggregate the values. (Go to Analysis -> uncheck Aggregate
measures)
From Show Me, Select Box and Whisker plots. And drop the Ship mode to the columns.
Hover on each of the boxes:
Median for the First Class and Same Day ship modes are 84.
Using the Regional Dashboard twbx file, find out the percentage of average obesity increases when 1% average increase in the physical inactivity in the New York state of the Northeast region?
Open Regional Dashboard twbx file, and select the region as Northeast and state as New York:
Hover the trend line of Obesity correlation with exercise chart, 0.57 percentage of average
obesity increases when 1% average increase in the physical inactivity in the Northeast Region.
However, we have to find out for the New York State. Currently, when you have selected the
New York state, the trend lines have not been recalculated.
To recalculate it, right-click on the trend line and click on Edit All Trend Lines:
In Trend Line Options, select the Show recalculated line check box:
Hover the trend line of Obesity correlation with exercise chart, 0.40 percentage of average
obesity increases when 1% average increase in the physical inactivity in the New York State in
the Northeast Region.
Using the Regional Dashboard twbx file, consider the Obesity dashboard to find out how many counties in North Carolina are having an obesity rate that is 8% below the regional obesity rate?
Here we have to use the Obesity View only, so let's go to that sheet:
Click on go to sheet as per above.
Edit the State filter and select only North Carolina:
Duplicate this sheet as Crosstab
3 counties in North Carolina are having an obesity rate that is 8% below the regional obesity
rate.
Note: For dashboard questions, I prefer to follow above approach wherever it is applicable. I
find it easy to get the answers.
Select the correct options that allow you to ensure that your Phone layout automatically reflects changes to the Default dashboard?
Refer: https://help.tableau.com/current/pro/desktop/en-us/dashboards_dsd_create.htm
Go to the section- Phone layouts and the Default dashboard