Create a calculated field with a name like "Blank" with a calculation similar to the following:.Click Size and adjust the slider all the way to the right.Drag the calculated field used to determine the color of the rows to Color.If there are more than 6 copies of, then at the bottom of the marks card, click "More Fields" and select "All".If there are 6 or fewer copies of on the Columns shelf, then click on the marks card labeled "All" to select it.Repeat steps 4-7 for every measure on the Measures Values card in the original worksheet.Repeat steps 2-7 for any dimensions on the Rows shelf in the original worksheet.Right-click the second copy of SUM(Container) on the Columns shelf and select Dual Axis.
Now the first column in the view contains city names and the second column is still blank. For the marks card for SUM(Container), drag onto Label.This will automatically open the marks card for this copy of SUM(Container) Click on the first copy of SUM(Container) on the Columns shelf.This step is necessary because if only one copy of is used to create each column, then the headers will be on the bottom of the view. Note: Tableau Desktop will show one marks card for each copy of container called: Sum(Container) and Sum(Container) (2). Drag two copies of onto the Columns shelf.Right-click on the Rows shelf and uncheck Show Header.The original view had two dimensions on the Rows shelf, and two measures, so we will need to create 4 columns in this view. After all of the columns are built, we will format all the columns at once.
These directions will build the view one column at a time.
In this example, the calculated field is named Container.
0 kommentar(er)
