How to create top 5 chart in Tableau
I have revenue data of 57 Brands for 7 years in excel sheet as shown below:
To create top 5 charts first I will load data into tableau from excel file. Then drag Brand into filter shelf. You will get filter window pop up. Goto tab 'Top'->select by field option->enter number 5->Select column revenue->Hit ok.
We have created filter, now just drag Year into columns shelf and Revenue into row shelf and Brand into colors as shown below:
To create top 5 charts first I will load data into tableau from excel file. Then drag Brand into filter shelf. You will get filter window pop up. Goto tab 'Top'->select by field option->enter number 5->Select column revenue->Hit ok.
We have created filter, now just drag Year into columns shelf and Revenue into row shelf and Brand into colors as shown below:
here is your chart ready every line series represent a brand
Now if you want to show this as Stacked chart so you find it disabled.
Just right click on Year -> select Discrete chart will get converted into stacked bar chart.
Other top chart options will also get enabled in 'Show Me' menu.
Comments
Post a Comment