Question

In: Computer Science

TABLEAU QUESTIONS! Create a calculated field Age that derives the age (as of the time of...

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)

Solutions

Expert Solution

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.


Related Solutions

Please create an Excel file with the calculated answers to the questions to the Excel homework...
Please create an Excel file with the calculated answers to the questions to the Excel homework for this week. The questions are listed in the attached PDF file.   Please also go over the Excel file attached to this assignment in order to familiarize yourself with the different ways Excel can be used to solve Time Value of Money problems when multiple cash flows are involved. There are three worksheets in the Excel file. This Excel file with examples is just...
In regards to tableau what is nested sorting useful for? sorting on a single field appearing...
In regards to tableau what is nested sorting useful for? sorting on a single field appearing in the last column sorting alphabetically on a field with long text sorting data using values in more than one field sorting both alphabetically and numerically on the same field
Ex. Create a GUI program to fill in the text field the performance time if each...
Ex. Create a GUI program to fill in the text field the performance time if each alignment method is used for 50,000 random integers. Each sort method is indicated by a button:Selection Sort ,Bubble Sort ,Insertion Sort ,Mergesort ,Quicksort ,Counting Sort ,Radix Sort ,Heapsort Write java code and show me the output. Thank you :)
Create a UI that has a field in which to enter text, a field to display...
Create a UI that has a field in which to enter text, a field to display read-only text and a button. When the button is pressed, take the value of the text box and try to create a month object. If a number was entered, use the constructor that accepts an integer. If alphabetic characters were entered, use the constructor that accepts a string. If nothing is entered, use the no-argument constructor. If a valid month object is created, use...
Considering the following time series data: (Tableau) Determine the least squares trend equation. Use a linear...
Considering the following time series data: (Tableau) Determine the least squares trend equation. Use a linear equation and any other non- linear equation. Provide R-squared for both cases. Estimate the price of gold (ounce) for 2020. Does this seem like a reasonable estimate based on historical data? What is the quality of the forecast? Also, Provide Mean Absolute Error (MAE), and the Mean Absolute Percentage Error (MAPE). Year Price of Gold (ounce) 2005 $513.00 2006 $635.70 2007 $836.50 2008 $869.75...
Considering the following time series data: (Tableau) Determine the least squares trend equation. Use a linear...
Considering the following time series data: (Tableau) Determine the least squares trend equation. Use a linear equation and any other non- linear equation. Provide R-squared for both cases. Estimate the price of gold (ounce) for 2020. Does this seem like a reasonable estimate based on historical data? What is the quality of the forecast? Also, Provide Mean Absolute Error (MAE), and the Mean Absolute Percentage Error (MAPE). Year Price of Gold (ounce) 2005 $513.00 2006 $635.70 2007 $836.50 2008 $869.75...
(10) Considering the following time series data: (Tableau) A. Determine the least squares trend equation. Use...
(10) Considering the following time series data: (Tableau) A. Determine the least squares trend equation. Use a linear equation and any other nonlinear equation. Provide R-squared for both cases. B. Estimate the price of gold (ounce) for 2020. Does this seem like a reasonable estimate based on historical data? C. What is the quality of the forecast? Also, Provide Mean Absolute Error (MAE), and the Mean Absolute Percentage Error (MAPE). Price of Gold (ounce) 2005 $513.00 2006 $635.70 2007 $836.50...
C++, Need to create a code that will calculated the statistics for character input? This is...
C++, Need to create a code that will calculated the statistics for character input? This is the prompt for the code. I truly understand nothing of what it's asking. Ask the user for one character (terminated by a carriage return).Using flow control, classify the character into one of these categories: 1)           vowel 2)           consonant 3)           digit (0-9) 4)           other Output the character input, its numeric decimal value, and the classification. Total up the number of each type of character entered....
Create a diagram of a current-carrying wire in a magnetic field. Draw the field lines and...
Create a diagram of a current-carrying wire in a magnetic field. Draw the field lines and explain how the direction of force acting on the wire is determined. #- Create a sketch of the experiment Michael Faraday performed, label all the parts, and write a brief explanation of how motion is created. thank you
Describe how the retention time of a peak is calculated if dichloromethane is injected with the...
Describe how the retention time of a peak is calculated if dichloromethane is injected with the sample
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT