Question

TABLEAU QUESTIONS!

• Create a calculated field Age that derives the age (as of the time of the trip) of the rider

  using their birth year. If the birth year is not available (i.e. NULL), Age should be NULL.

• Create a viz in a worksheet named “Number of Trips by Age” that shows the number of

  trips for riders of every age. Use any appropriate chart type for this viz. In this viz,

  exclude any data for unknown (NULL) ages. (Recommendation: use column chart)

• Categorize the age of the rider into 4-6 categories using a calculated field named Age

  Category. One of the categories should be comprised of all unknown ages.

• Create a viz in a worksheet named “Average Trip Duration by Age Category” that shows

  the average trip duration for every one of your age categories. You can use any

  appropriate chart type for this viz. (Recommendation: use bar chart)

• Parameterize one of the limits of your age categories. Make sure that your parameter is

  of the appropriate data type (Integer) and the range of its value is set appropriately. Create a new calculated field named Age Category 2 that implements the parameterized categorization.

• Create a viz in a worksheet named “Interactive Number of Trips by Age Category” that shows the number of trips for all of your age categories and shows the parameter control, so the viewer can change it. Use any appropriate chart type for this viz. (Recommendation: use bar chart or pie chart)

Answer 1

I cannot see your dataset, or a sample of your data, so I'm gonna help you with the max I can do with the question.

Step1: Go to Tableau and click on New from the Tableau menu.

Step2: This will redirect you to a new workbook, where you can connect your book to an external data source like a Excel sheet/CSV file.

Step3: Click on Connect to Data and choose the type of data source, and select it from your file explorer.

Step4: Your data should have primitive field's like the rider's name, his DOB etc.

Step5: To create the Calculated field, go to the Analysis tab of the menu and select Create Calculated Field. Enter a name for the calculated field. In this example, the field is called Age.

Step6: Enter a formula to this field. For example here, for the Age, enter:

1. IF DATEADD('year', DATEDIFF('year', [Birthday], TODAY()), [Birthday])> TODAY() THEN
2.     DATEDIFF('year', [Birthday], TODAY())-1
3. ELSE
4.     DATEDIFF('year', [Birthday], TODAY())
5. END

Step7: When finished, click OK. The new calculated field is added to Measures in the Data pane because it returns a number. (All calculated fields have = signs next to them in the Data pane.

Step8: Now it's time for the visualization. Drag the calculated field 'Age' to the columns bar on the top, and the field which has the number of trips in the rows bar. Select the Bar/Column chart option in the right side panel consisting of the variety of the viz.