1. Download the free trial of Tableau (link in the Resources). 2. Install Tableau on…
- User
- Download the free trial of Tableau (link in the Resources).
- Install Tableau on your computer and register an account with the same email you used to download the software.
- Download the daikibo-telemetry-data.json.zip file -> unzip -> and import it in Tableau.
- Create a calculated measure field called "Unhealthy" with a value of 10 for every unhealthy status (representing 10 mins of potential down time since the previous message).
- Create a bar chart called “Down Time per Factory”.
- Create a new sheet with a new bar chart called “Down Time per Device Type”.
- Create a Dashboard with the 2 previous sheets and set the first chart to be used as a filter (selecting a factory in the first chart shows only the down time of the machines in this factory in the second chart).
- Select the factory with the most down time (click on its bar), make a screenshot of the dashboard and upload it as a submission for this task.
these are the things i have to do... and i completed till task 3... now can you tell me the steps how can i do other tasks as well
Assistant
Certainly! Below are the step-by-step instructions to complete the remaining tasks in Tableau:
Task 4: Create a Calculated Measure Field Called "Unhealthy"
- Open Tableau and connect to your
daikibo-telemetry-data.jsonfile (if not already connected). - Go to the Data Source tab (bottom-left corner).
- Right-click on the data source and select "Create Calculated Field".
- Name the field
"Unhealthy". - Enter the formula:
(This assignsIF [status] = "unhealthy" THEN 10 ELSE 0 END10for every "unhealthy" status, representing 10 minutes of downtime.) - Click OK to save the calculated field.
Task 5: Create a Bar Chart Called “Down Time per Factory”
- Create a new sheet (click the "+" icon next to "Sheet 1").
- Drag "factory" to the Columns shelf (this will be the x-axis).
- Drag "Unhealthy" (the calculated field) to the Rows shelf (this will be the y-axis).
- Change the chart type to a bar chart (if not already):
- Right-click on the chart → "Show Me" → Select the bar chart option.
- Rename the sheet to "Down Time per Factory" (right-click the sheet tab → Rename).
Task 6: Create a New Bar Chart Called “Down Time per Device Type”
- Create a new sheet (click the "+" icon).
- Drag "device_type" to the Columns shelf.
- Drag "Unhealthy" to the Rows shelf.
- Change the chart type to a bar chart (if needed).
- Rename the sheet to "Down Time per Device Type".
Task 7: Create a Dashboard with the 2 Charts and Set Up Filtering
- Create a new dashboard (click the "New Dashboard" button).
- Add both sheets to the dashboard:
- Drag "Down Time per Factory" to the left side.
- Drag "Down Time per Device Type" to the right side.
- Set up filtering:
- Click on the "Down Time per Factory" chart.
- Right-click on the factory name (e.g., "Factory A") → "Keep Only" (this will filter the second chart).
- Alternatively, you can use Actions for dynamic filtering:
- Go to Dashboard → Actions → Add Action → Filter.
- Set the source as the first chart and target as the second chart.
- Adjust layout (resize charts as needed).
Task 8: Select the Factory with the Most Down Time and Take a Screenshot
- Identify the factory with the highest "Unhealthy" value (longest bar in the first chart).
- Click on that bar to filter the second chart.
- Take a screenshot of the dashboard (use
PrtScnorSnipping Toolon Windows,Cmd+Shift+4on Mac). - Save the screenshot and upload it as your submission.
Final Checklist
✅ Calculated field "Unhealthy" created. ✅ "Down Time per Factory" bar chart created. ✅ "Down Time per Device Type" bar chart created. ✅ Dashboard with filtering set up. ✅ Screenshot taken and submitted.
- Open Tableau and connect to your
Other models, same or similar prompt
Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.