I have three fields-
Office_ID
PL_ID
STAGE_ID
I need to calculate for Every OFFICE_ID ( there are 4 of them) what % of PL_ID has STAGE_ID populated and what % has Stage ID as NULL.
How do I do it?
Please help
Newbie.
Tableau file attached
3 answers
Hello Prati Bajwaji,
Here it is:
These are Calcs:
With Stage ID
({FIXED [Office Id]:COunt(IF NOT ISNULl([Stage Id]) THEN [Pl Id] END)}/{FIXED [Office Id]:COUNT([Pl Id]) })
Without:
1-With Stage ID
First Calc can be Shortened as:
{FIXED [Office Id]:COunt(IF NOT ISNULl([Stage Id]) THEN [Pl Id] END)/COUNT([Pl Id]) }
Thanks
Deepak
If it Helps, Pl Mark it Helpful and CORRECT to Close Thread
