We can make our data more readable by filtering down to a smaller time window. But there are too many marks squeezed into the view. Right-click (Control-click on Mac) the SUM(OrderUntilShip) field on the Marks card, and then select Measure (Sum) > Average. The default aggregation for OrderUntilShip is Sum, but in this case it makes more sense to average the values. The formula creates a custom measure that captures the difference between the Order Date and Ship Date values, in days.ĭrag the OrderUntilShip measure to Size on the Marks card. In the Formula box, enter the following formula and then click OK:
In the calculation dialog box, name your calculated field OrderUntilShip.Ĭlear any content that's in the Formula box by default. You can also right-click (Control-click on Mac) any field in the Data pane and select Create > Calculated Field. In the toolbar menu, click Analysis > Create Calculated Field. To do this, create a calculated field to capture that interval. Next, we'll size the marks according to the length of the interval between the order date and the ship date. This builds a two-level nested hierarchy of dimensions along the left axis. Drop Ship Mode to the right of Sub-Category. Individual weeks are indicated by tick marks because there are 208 weeks in a four-year span-too many to show as labels in the view.ĭrag the Sub-Category and Ship Mode dimensions to the Rows shelf. On the Columns shelf, click the Year (Order Date) drop-down arrow, and then select Week Number. Tableau aggregates the dates by year and creates column headers To create a Gantt chart that shows how many days elapse on average between order date and ship date, follow these steps:Ĭonnect to the Sample - Superstore data source.ĭrag the Order Date dimension to Columns. The basic building blocks for a gantt chart are as follows:įor more information about the Gantt bar mark type, see Gantt Bar mark. You might use a Gantt chart to display average delivery time for a range of products.
In a Gantt chart, each separate mark (usually a bar) shows a duration.
0 kommentar(er)
