Generally, in organizations
you will get similar kind of single line problem statements. It’s important
that how you will understand this problem statements and convert them into meaningful
insights. Usually I will convert problems statements into simple logic steps. Then
I will start thinking about how to solve them using technology.
Here the above statement, I will convert into following
steps.
Step 1:
Find current month sales
Step 2:
Identify Top 5 states by current month sales
Step 3:
Show monthly sales trend for Those Top 5 Sates.
Now we will see how to do these steps in tableau.
Step 1:
We will write calculation filed for current month
sales. Later we can use this calculation to find Top 5 sates by current month
sales.
Step 2:
This Step you can do in two ways.
Method 1:
Using Top option in Filter selection.
Method 2:
Using Sets in tableau. Create a top 5 States set by Current
month sales.
Step 3:
Finally show monthly trend for those Top 5 sates.
Method 1:
Method 2:
This is how I solve problems in tableau. I like steps approach
in problem solving.