Thanks a lot Jennifer. Your quick reply is much appreciated.
Unfortunately, I found that I have one more row in the dataset which I missed. Here is the complete dataset ---
RAW DATA Sample ---
I also found that I can not change the datatype to BOOLEAN. How do I solve the issue in that case?
Also, please note that CPU_Count in your solution does not show the value I am expecting.
Regarding your field not being Boolean, no problem. The IF statements work just as well with strings, so these fields can now be:
MAX(IF [Is Virtual] = 'TRUE' THEN 1 END)
MAX(IF [Is Virtual] = 'FALSE' THEN 1 END)
MAX(IF [Is Virtual] = 'UNKNOWN' THEN 1 END)
Regarding the CPU count not showing what you're expecting, you'll have to provide more information on the logic you want to happen here. Under what circumstances do you want the cpu count to be "Total across Servers")? What issue are you trying to solve for, or what steps have you taken to get to your end result that you're trying to replicate in Tableau?
Regarding the extra row with "Unassigned", what is meant to be done with it?