Skip to main content

i will give you all three calculations - 

  

HH size -  

IF [Number of Active Contacts Above 2yrs] IN (1, 2, 3) THEN "Small" 

ELSEIF [Number of Active Contacts Above 2yrs] IN (4,5) THEN "Medium" 

ELSEIF [Number of Active Contacts Above 2yrs] >= 6 THEN "Large" 

END 

 

MOSR -  

IF [TV Signal Reception Code] = 'Cable Operator with Set Top Box' THEN 'Cable' 

ELSEIF [TV Signal Reception Code] = 'DTH' or  [TV Signal Reception Code] = 'Free DTH' or  contains([TV Signal Reception Code], 'Using internet connection') then 'Others + Streaming' 

ELSEIF  [TV Signal Reception Code] ='Pay DTH'   then 'Pay DTH' 

ELSEIF contains(([TV Signal Reception Code]),'Fiber Cable with Set top box') THEN 'Fiber cable' 

ELSEIF  CONTAINS(([TV Signal Reception Code]), 'JIO FIBER') then 'Fiber cable' 

END 

 

Installed count -  

{ FIXED     [Pmaid]: 

MAX( 

IF 

 [Household Status1] IN ('Installed', 'Training2') 

AND [Panel Type] = 'Premium Panel' 

 

THEN 1 

END 

 

Now i want HH size & MOSR in one view which shows Installed count, what is happeing is : 

HH size = 1326 (small hh) 

but on add MOSR my hh size count is changing to 1398  

I tried LODs, but its not working 

basically i want to use tow different categories but both shoudl not change thier actual count w.r.t other 

 

#Tableau Desktop & Web Authoring

4 answers
0/9000