I want to make chart displaying count number of values in column (null as one value).
2
votes
2 Answers
2
votes
I'm new to Tableau, so I've only been able to solve your problem partly -
- In
Rows
Shelf, add yourField_Name
. - In
Marks
Card, double click to create a fresh criteria, and enter text -COUNT([Field_Name])
- Choose category of the criteria as
Text
instead of Details
This creates a list of unique items in your List and their counts; except for the Null values (My dataset contains 2 Null
entries).
Note: The counts of the null values can be checked by clicking the Null 0
row, and selecting the Full Data
tab from View Data...
2
votes
Upon digging into Tableau fundamentals, I learnt that you can do this with 2 simple steps:-
- You may place the attribute in
Row
Shelf. - In the Navigation Panel on the left, under
Measures
section, you'll find something calledNumber of Records
ORExcelWorksheetName (Count)
in italics. Drag that into the Data area of the visualization.
This approach gives you the Null counts as well! :)