Tableau - Error when COUNT boolean T/F

0
votes

My goal here is to count the # of True, False and NULL per day using my boolean calculation. Next step would be to calculate the percentage of each T, F, N with overall day.

Below is the visualization I would like to achieve but instead of blue dots, I would need the count of them in number.

enter image description here

Initially, I tried

IF [boolean] THEN 1 ELSE 0 END

But only changing from True to 1, False to 0 and missing the NULL - not counting:

enter image description here

I also tried different Calculated Fields to get the count of it but always getting the same error:

SUM(IF [Field]=TRUE then 1 else 0 end)

COUNT(IF [Field]=TRUE then [ID] end)

ERROR:

enter image description here

Could someone please assist me with a Calculate Field or any other solution where I could get a count of T, F, and NULL that would also assist me with the percentage?

Thank you

1
tableau-api

1 Answers

0
votes

You're working too hard.

Just put SUM(Number of Records) on one shelf with DAY(Disconnected ...) on another, with the Boolean field that classifies data rows as > 0 or not on some other shelf, such as Color. No need for a table calc.

Here is an image of a solution posted at https://community.tableau.com/message/601862#601862

enter image description here