The public file is not downloadable.
If you have a small data set, I would just load the data source twice. Apply data source filters to each so one only includes 'Yes' and the other includes 'No'. Blend on Sensor ID. And then drag the temperate measures from each data source to the viz. Let me know if you need a further breakdown of directions.
Dear John, Thanks for the advice! But I didn't manage to load the Excel file twice as you suggested and apply the filter. Can you kindly help to illustrate a bit more? I've made the Tableau Public file downloadable now.
Thank you very much!
1 of 1 people found this helpful
Hi Yuri -
1) Open tableau and click excel then navigate to your xlsx to load it into tableau.
2) Click on Sheet one at the bottom of the application.
3) Right click on the data source and click 'edit data source filters'
4) Click 'add' then select 'Window Open' Then check 'No'. Hit ok. then ok.
5) click on the data source tab at the bottom of the application.
6) click on the cylinder next to the data source name. And click 'new data source. You basically repeat the process except you'll check 'yes' when you get back to step 4 above.
7) when you click back over to sheet 1, you'll see both data sources. Make sure to set your data source filter for he second one following the steps above.
8) At the top of the application, click 'data' and click 'edit relationships.
9) For your data source, I'd click on custom. The remove Window Open and Location. Just sensor id should be sufficient for your data source. Hit ok.
10) Right click and drag each Temp measure from both data sources to the row or column shelf. Select the top option each time.
11) should look like this.
Dear John, Thank you very much for the detailed step-by-step explanation! I've learned a lot from your advice!
Not a problem Joe. Feel free to like my response or even mark it correct if it's appropriate
Yes, John, marked your advice as the correct and helpful answer.
Thank you very much, once again!