Computed Sets Vs. LODs

-

Computed Sets Vs. LODs:


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 only gives the In/Out.For that we use Fixed LOD expression:
Put the Product name to column shelf, on drop down select the measure ,then select the count(Distinct)
 Create a calculated field for "Regions Per Product"

{ FIXED [Product Name]:COUNTD([Region])}

"Regions per product" calculated field create on measure section, just drag that field and on Dimension field.After that put that into Rows shelf.

If you want to percent of total then goto drop down of Count(Product Name) ,click on Quick table calculation then choose "Percent of Total".



If you want to see how many products are sold in 2 regions using fixed LOD then 

{ FIXED [Product Name]:COUNTD([Region])}=2


Comments

Post a Comment

Popular posts from this blog

Rank Function in Tableau

-
Rank function : you can create a calculated field using Rank function. Rank(expression,[‘asc’],[‘desc’]) For  example of rank function we take below table Example:  Stores Sales A 10 B 20 c 20 d 40 e 50 a.        If we use ‘ Rank(Sum([Sales])) ’ we get the result as Stores Rank Function Sales A 5 10 B 3 20 c 3 20 d 2 40 e 1 50 Here rank 4 is skipped. b.       Rank_Dense () RANK_DENSE(sum([sales])) Stores Rank Function Rank Dense function Sales A 5 4 10 B 3 3 20 c 3 3 20 d 2 2 40 e 1 1 50 On this same number gives the same rank. on above example on two cells sales amount is 20 . then it gives same rank to both. c.        Rank_modified() Create a calculated field using rank_modified function  Rank_modified(expression,[‘asc’I...
Read more

DATE FUNCTION IN TABLEAU

-
DATE FUNCTION :   1.          DATEADD   Function :  DATEADD(date_part, Interval, date)  Example : DATEADD(‘day’,15, #2014-09-15#)  = 2014-09-30  12:00:00 AM       2.   DATEDIFF   function   : DATEDIFF(date_part,date1,date2, start_of_Week )  : ‘Start_of_Week’  is not mandatory    DATEDIFF(‘day’,#2014-09-05#,#2014-09-20#)  = Five 3.          DATENAME Function :  DATENAME(date_part, date, [ start_of_Week] )  : ‘Start_of_Week’  is not mandatory  DATENAME(‘Month’,#2014-09-01#)  = “September” Datename(‘weekday’,[order Date])= Sunday,Monday,Tuesday,…,Saturday) DATENAME('month',[Order Date])=January,February,March,…. DATENAME('week',[Order Date]) (Week number)      4.   DATEPARSE Function : DATEPARSE(format,String)   This date functions prim...
Read more