Categories
Tableau

Creating Scatter Plot and Dashboard in Tableau

Last Post we implemented Hierarchy In Tableau.Here we can see How to create Scatter Plot and Dashboard in Tableau.

This was the worksheet that we worked on last project.Now we can start a new work sheet by clicking the new worksheet tab at the Bottom as shown in screen Shot:

Screenshot 2020-08-07 at 18.02.55

Next we can see how generate a Scatter Plot in Tableau.Let us say you need to calculate profit of each customer based on sales in different years.

For that First Drag and drop the Sales and Profit Columns and Rows respectively. Then drag Customer Name to details as shown below:

Screenshot 2020-08-05 at 22.55.16

Now we need to apply the Filter across all worksheets.That is all worksheet should show the same selected year data.For that Go to Filter then Right Click then select Apply to Worksheet then select All Using Data Source.

Screenshot 2020-08-05 at 22.52.39

Now you want to analyse both work sheet together in this case you can create a Dash Board and put both sheets together in it .In order to create Dash board go to Bottom tab select the Dashboard as shown in figure:

Screenshot 2020-08-07 at 18.06.01

Now Drag and drop the work sheets in to dash board as shown below:

Screenshot 2020-08-05 at 23.08.07

Now you can analyse both sheets data together using a dashboard.

scatterplot

Hope you enjoy the post.

Later,

Smile

Preethi

By Preethi Kishore

I have had multiple incarnations. I worked as a Researcher, Lecturer and as a Developer, but one thing has always been a constant, my passion for Computer Science. This is my first attempt at writing a blog, I believe I can do Justice to this endeavor as well as I was able to contribute to all my previous incarnations and would be able to call myself in future as a Blogger and someone who helps in someway to make technology more accessible and interesting to learn.

Leave a comment