Hi guys ,I am back with a small blog. But this will be very helpful ,if you want to show details of data from a webpage.
without further delay, let's do the work
Prerequisite
I am using Tableau public for creating this workbook
The dataset used for this is sample-superstore
Steps
Connect to the data source
2. Place the state in detail in the mark pane
3. Change the chart type to map in the mark pane and place the sum(sales) to the color in the mark pane
4.Put the state and sum(sales ) in the label
5.Change the sum(sales) currency format to dollar.
6. Now go to the worksheet menu, there take actions>>from the actions window click on add action>>go to URL
7. In the add URL action window>>select menu>>give a name for the hyperlink .In the worksheet, I want to show details of states when I move the tooltip over the states. so in the URL section of add URL window I have added a wiki link: https://en.wikipedia.org/wiki/ >>then click insert >>state. Then the URL will be https://en.wikipedia.org/wiki/<State>
8. Now when we go over the states, we can see from the tooltip details the wiki link will be shown
9. Click on the wiki link, it will take you to the Wikipedia page with the details of the state
Now to create a dashboard with a webpage shown when we select a state.
1. Make size: automatic in the dashboard, drag the sheet to the dashboard. Then we will add action from the dashboard menu(make sure it is from the dashboard menu, not from the worksheet menu.)
2. Then add the wiki action to the dashboard action
3. There will be already one action from the worksheet remove it because the new action of the URL will work by selecting the state
4. If we want to see the URL page details in the dashboard itself then, click on the webpage in the objects of the dashboard
5. Then add the wiki URL to the edit URL window
6 Then arrange the dashboard in such a way we want to see the details, when we click the state
Comments