I would probably do this with a dual axis chart where one chart graphs the number of records and the second one graphs a calculation that looks something like:
IF ISNULL([EMAIL]) OR ISNULL([PHONE#]) then 1 ELSE 0 END
Synchronize the axes and have the second chart overlay the first one.
Hi david thanks for the response.
That was not working.
Now I have changed the data. It looks like this now-
Type Good Or Not Book1 Bad Book3 Good Book3 Good Book1 Good Book2 Good Book2 Good Book1 Good Book1 Bad Book3 Bad Book1 Good
I need to get the count of records like this and visualize in tableau-
Good Bad Book1 3 2 Book2 2 0 Book3 2 1
can you help now?
Thanks David It solved my problem!
It looks like you already received a couple of answers to that question.