Computed Sets Vs. LODs
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...
Comments
Post a Comment