Tableau Concept And Data Visualization

Computed Sets Vs. LODs: https://public.tableau.com/profile/ritimugdha.das2797#!/vizhome/ComputeSetVs_LOD/ComputeSetVs_LOD How Many Products are sold in Two Regions: Using Sample Superstore Data Set: Method 1:(Using Set) Create a set ,Right click /Click on drop down of Product name then select create then click on Set. Create set page is open .Give the name of set what you want to create.Now I create a set with name "Product in Two Region" Go to Condition,Click on By field radio Button, then on drop down you needs to select "Region",Count(Distinct),=2.While Clicking on ok. "Product in two Region" set will be created. Take the "Product in Two Region"set to rows shelf and Product name to column shelf. Take the Product name to column shelf and on drop down of product name ,choose measure and select count(Distinct). Method 2:(Using Fixed LOD expression) How Many Products are sold in 1,2,3 or 4 Regions: Sets onl...

How to Create Grouped Bar Charts in Tableau: Click Here to connect with Tableau Public Explained Through an example , its easy to understand: use the sample superstore data set Steps: 1. Take sales to rows shelf and Region and Category ti Rows shelf. 2. Again take category to Mark card colour section , then its looks category wise different colour. 3. Then go to analysis tab, then select Totals, then click on Add all subTotals 4. Click on Total bar 5. on Automatic dropdown select the Average: 6. Again goto Automatic drop down and select Hide 7. Select Total,Right Click,Then click on Format. 8. From totals Remove the Label, means Keep the label as blank. 9. Click on category drop down and click on Show Header.  10. How to Region name comes to the middle of the bar? For that we need to create a calculated field for "region on middle"  IIF(INDEX()=2,ATTR([Region])," ") After that click on Default Calcula...

How to Use Set Actions to Maintain the Rank of a Dimension Upon Filtering: https://public.tableau.com/profile/ritimugdha.das2797#!/vizhome/HowtoUseSetActionstoMaintaintheRankofaDimensionUponFiltering/HowtoUseSetActiontoMaintainTheRank  Example: We take the Sample Super store Data We Rank the subcategory According to the sales: Steps:     i) Take sales to Column shelf    ii) Sub-Category to Rows shelf   iii) Sort the sub-category according to sales.   iv) Again take sales to Label.   v) Then change that to Rank.  RANK(SUM([Sales]))  vi)  If we take sub-category into filter and shows filter then it looks like below mentioned image :  vii) On above mentioned Storage rank is 3. On filter section, if we deselect all and select only Storage on filter, Then Rank changes or reset to 1.   viii) We fix that using Set Action. Remove the sub-category to filter se...