Last Modified Date: 20 Jul 2023
Environment
Tableau DesktopAnswer
Use the following workaround to display months only for Q3.
Step 1: Create a Parameter
- In Tableau Desktop, connect to the Superstore sample data.
- Right-click in the Data window and then select Create Parameter.
- In the Create Parameter dialog box, do the following, and then click OK:
- Name the parameter. In the example workbook, the parameter is named Quarter.
- For Data Type, select Date.
- For Allowable values, select Range.
- Click the boxes next to Minimum and Maximum, and keep the default values.
- Click the box next to Step size, select 1, and then select Quarters from the drop-down list.
- Right-click the new parameter and then select Show Parameter Control.
Step 2: Create a Calculated Field
- Select Analysis > Create Calculated Field.
- In the Calculated Field dialog box, do the following, and then click OK:
- Name the calculated field. In the example workbook, the calculated field is named Telescope Months.
- In the formula field, create a calculated field similar to the following:
IF DATEPART('quarter',[Order Date])=DATEPART('quarter',[Quarter])
THEN DATENAME('month',[Order Date])
ELSE "ALL"
END
Step 3: Build the View
- Drag Order Date to Rows.
- On Rows, right-click YEAR(Order Date), and select Quarter (Q2).
- Drag Sales to Columns.
- Drag Telescope Months to Rows.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials