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
RowsShelf, add yourField_Name. - In
MarksCard, double click to create a fresh criteria, and enter text -COUNT([Field_Name]) - Choose category of the criteria as
Textinstead 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
RowShelf. - In the Navigation Panel on the left, under
Measuressection, you'll find something calledNumber of RecordsORExcelWorksheetName (Count)in italics. Drag that into the Data area of the visualization.
This approach gives you the Null counts as well! :)



