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
@Namrata Nagvekar glad it did. Kindly Accept the answer so people with similar problem land at the right place for a solution. Thank you.