Hi try this
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Can you attach a workbook? There are some data densification techniques that'll help you to get around that.
Hi Jim, It's not a null value. There are no value to show, there will be 0 marks basically. Tableau defaults it to 'None' when there is no marks i want to show 0 instead
I use the below Measure Calculation in title which shows the number of entries on the table.
ZN(Total([Sum of Number of Product]))
the formula fills the voids (no values ) with 0
give it a try -
It still shows 'None'
Is there any way to over come this ? When ever there is 0 marks aka no rows or data. I am seeing "None". How can we show '0' instead.
Step i am following:
Dragging the "Number of Records" field to text mark and adding "Total Number of Records: SUM(Number of Records)". This becomes "Total Number of Records: None" when there are no records to display.