2 weeks ago
Hi
I am currently building in Datasphere but I ran into a small problem. The fields that contain no values (displayed as '-' in datasphere, get filtered out later on in my view. But fields that have a '0' as value, do not get filtered out. So an "easy" solution to this seems to convert all the empty fields into '0', but I do not manage to find the expression for this. Anyone who can help me? Thanks in advance
You can create a formula that checks your dimension. Something like:
case when "MY_FIELD" is null then 0 else "MY_FIELD" end
And then use that in your views instead.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
'-' at database level is NULL.
But if you look at it in dataflows it really is '-' if you need to filter it out.
and if you have a date type field you need to use '-' to filter it out anyway.
(i've never unverstood why)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
76 | |
9 | |
8 | |
7 | |
6 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.