I need to rename '-' in graph.
I understand, how to rename empty field (5.9%), but this doesn't work with '-'.
Also it would be perfect to unite empty fields and '-' (nulls) and rename it.
Thanks in advance!
I suggest you do this in the script:
set NullValue='new name';
(Haven't tested it!)
change your dimension to a calculated dimension like the following
I've tried, but with =0 it renames empty fields, but not "-".
Use the isNull() statement if you really want to implement a conditional statement.
Have you tried editing this in the database view? Depending on database, you can use case, nvl or if clause to construct null rename.
You can use the powerfull function alt like this:
alt([your field or expression], 'Null Values') this will give null values the label 'Nulls Values'.
Hope it helps you
thanks, but it doesn't help. I can't understand what is the difference between - and empty fields. All functions change smth in empty, but nothing works with '-'
You clearly didn't read the post or you don't know how alt() works :)!
may be try this
if(IsNull(filed name),'xxx',field name)
Retrieving data ...