Top 4 , Create calc field Use rank function Rank(sum(sales)) Put it in text and compute using pan down After ctrl + calc. Field put this in filter select range 1 to 4.. done You will get region wise top 4 state by sales...
Top 4, Can create a set of top states with respect to sales Create a viz with states and sum(sales) Put top state set and region to filter shelf, then apply region to context filter It will do the the job
Top N of each region Drag Region, State to Rows shelf Drag State to Text/Label Create Calculated field Index → INDEX() Make it discrete Drag to Rows shelf Edit Table Calculation > Specific Dimensions > Restarting every Region Done. 👍🏻 How to make it dynamic? Use Parameter instead of Filter.
We can ans this question in two ways 1) by adding context fiter ->Drag & Drop the region,state into filter and Row shelves and sales into columns. -> sort by state desc, And filter top 5 states . ->in Filter shelves add Region as Contex and click on show filter. ->select Centeral region in quick filter . Then you will get region wise top 5 states. ->Done 2) by creating Rank Calculat fileds . -> drag & drop region, states into row shelves,and Sales into Column shelves. ->sort by state descending order ->create a Calculate filed name As 'Rank' "Rank (sum(sales))". -> Drag & Drop Rank calculat fields into Filter shelves then Select range of values min 1- max 5 ->drag & drop Region into filter shelves and select Central region. ->drop sum( sales ) into Mark 'Label'. ->Done. Note:- if there is any alternative way to solve the question pls let us know. . Regards, ###Naga
First you make a set for Top N customers, then you make a calculated field IF [top 5 cust] = True then [Customer Name] ELSE 'OTHERS' END And show this calc field as x/y axis
for region wise top 4 states, rgion,states to Rows shelf and sum(sales) to column. drag region to filters shelf make it a context filter create a calculated field with RANK(Sum(Sales)) then drag calculated field to filter shelf , select the rang 1 to 4 right click on the filter > compute using > Pane down You will get the required visualiztion
Top 4 ,
Create calc field
Use rank function
Rank(sum(sales))
Put it in text and compute using pan down
After ctrl + calc. Field put this in filter select range 1 to 4.. done
You will get region wise top 4 state by sales...
Top 4,
Can create a set of top states with respect to sales
Create a viz with states and sum(sales)
Put top state set and region to filter shelf, then apply region to context filter
It will do the the job
Top N of each region
Drag Region, State to Rows shelf
Drag State to Text/Label
Create Calculated field Index → INDEX()
Make it discrete
Drag to Rows shelf
Edit Table Calculation > Specific Dimensions > Restarting every Region
Done. 👍🏻
How to make it dynamic?
Use Parameter instead of Filter.
To show the correlation between two measures
the best chart is 'scatter plot'
Top 4 for each region, go for index or rank and use compute using region from calc
For top4 ...you have to use context filter...this is was expect from interviewer
Brother you are the best
Top 4 communities he is visualization ...sales ,and others counters...we have to slove that problem
We can ans this question in two ways
1) by adding context fiter
->Drag & Drop the region,state into filter and Row shelves and sales into columns.
-> sort by state desc, And filter top 5 states .
->in Filter shelves add Region as Contex and click on show filter.
->select Centeral region in quick filter . Then you will get region wise top 5 states.
->Done
2) by creating Rank Calculat fileds .
-> drag & drop region, states into row shelves,and Sales into Column shelves.
->sort by state descending order
->create a Calculate filed name As 'Rank'
"Rank (sum(sales))".
-> Drag & Drop Rank calculat fields into Filter shelves then Select range of values min 1- max 5
->drag & drop Region into filter shelves and select Central region.
->drop sum( sales ) into Mark 'Label'.
->Done.
Note:- if there is any alternative way to solve the question pls let us know.
.
Regards,
###Naga
after giving this interview... did u get the job??
Top 4
with the use of context filter
Hai I am not getting in tableau 4 years
Suggest me any companies in bangalore location
Side by side bar chart is good for target ???
no, you can use bullet chart
how to achieve that top 10 and other customer as aggregated scenario ?
?
First you make a set for Top N customers,
then you make a calculated field
IF [top 5 cust] = True then [Customer Name]
ELSE 'OTHERS' END
And show this calc field as x/y axis
Thank you bro 👌👌
for region wise top 4 states,
rgion,states to Rows shelf and sum(sales) to column.
drag region to filters shelf make it a context filter
create a calculated field with
RANK(Sum(Sales))
then drag calculated field to filter shelf , select the rang 1 to 4
right click on the filter > compute using > Pane down
You will get the required visualiztion
Good job
Welcome Asutosh. Make sure you are validating the answers. as this video is old one and not all answers are correct.
for tableau 5 years exp how much package we want ask in interviews for hyderabad location?
14 lpa I guess
Great content. 👍👍👍
Thank you 👍
Trails version runs how many months
Its lifetime
how many years of experience you put in your resume
5 years
Temporary dsta will be you're dates..
Take one project and explain by writtenally for interviews in how to explain projects in interview
Can u do a video for the project explanation
Yes, this would be my next video
YOU GOT SELECTED...
use context filter on region , and apply top 4 condition on sales
this will not work.. as context filter and top 4 condition comes at same level of operation
good one bro