Hi All,
I create barchart that include 1 dimension and 1 measure.
In the barchart I get null values in the dimension but only when I add the measure that arrived from other table (there is no null values in the dimension itself ).
I want to change the null values in the dimension to 'N/A' , but when I add the following calculation in the dimension it doesn't work because there is null data in the dim just when I add the measure :
if( IsNull(Region)=1,'N/A',Region)
I see there is "Null symbol" option in vizlib table and its work fine but I need to display the data as barchart\combochart and I don't see such an option there..
Any advise?
Thanks!