Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a issue .
i have one filter like
Year
2000
2001
2002 lik dat ..... and i have a bar chart . so my requirment is :
in that years i have some null values. so when i ever i clik on any year for that year null values should display on chart?
how can i do this?
Thanks in advance
Best
Chanty
NULL is not a value, so I am not sure what you want to show in your chart.
Maybe the count of records with NULL?
=NullCount(Field)
NULL is not a value, so I am not sure what you want to show in your chart.
Maybe the count of records with NULL?
=NullCount(Field)
How can you display null values? You mean to display the count of Null value?
May be Year as dimension and NullCount(Value) as Expression?
yes sunny....
but if i want show in Pivot or stright table ? how can i do this?
The same way as Stefan and I mentioned. Add an expression NullCount(Value) with year as your dimension and all other dimensions you may have
thnku stefan and sunny