![]() ![]() In the Drop Field dialog, select CNTD(Order ID) and click OK.Right-click and drag from the "Sample - Superstore (link on order date)" data source onto Text on the Marks label.In the Edit Alias dialog, type in a more descriptive name and click OK.In a new worksheet, right-click and drag from the "Sheet1 (master date list)" data connection into the view.Click OK to close the Relationships dialog.Repeat steps 4-5 with "Sample - Superstore (link on ship date)" as the secondary data source, and adding a relationship on MY(Date) = MY(Ship Date).Select the matching date level for Order Date.In the right pane, click the arrow next to Order Date.Select the date level that matches the most granular date level used in the view.Click the arrow next to Date to expand the date options.In the Add/Edit Field Mapping dialog, do the following:.For secondary data source, select Sample - Superstore (link on order date).For Primary data source, select Sheet1 (master date list).In the Relationships dialog, do the following:.In this example, I have named the two copies of "Sample - Superstore" as "Sample - Superstore (link on order date)" and "Sample - Superstore (link on ship date)" for clarity. Navigate to Data > Sample - Superstore > Duplicate.In this example, that connection is called "Sheet1 (master date list)" Create a table that contains a master list of all possible dates, and create a new connection to that list.This option will not work for a range of dates. Double-click in the data pane to add the field to the view.In the Drop Field dialog, select MY(Date) and click OK.In the formula field, create a calculation similar to the following:.In this example, the calculated field is named "Orders Placed" ![]() In the Calculated Field dialog box that opens, do the following, and then click OK:.Select Analysis > Create Calculated Field.Add the "Sheet 1" table to the canvas area.Navigate to the Data source tab in Tableau Desktop.In this example, that table is called "Master Date List" ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |