Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have some columns in the dimension.
In that dimension there some values along with the null values.
for example --
dimension ---country
there is 5 country along with two bank values
then
in the measure by expression i want to display total number of country as 7(5values+ two blank values) not 5 only
How can I display the blank values?
I tried this:-
In data load editior:-
If(len(Trim(Play_Active_Type))=0,1,Play_Active_Type) as flag
In expression :-
Flag={'1','unknown','other:specify'}
it's working fine.
if you mean null values you have to check "Include null values" under dimension.
I tried but it's not working
did you also check the option "Include zero values" under Add-ons->Data handling ?
yes,but nothing happened
what's your measure expression ?
please send a screenshot to understand more.
I tried this:-
In data load editior:-
If(len(Trim(Play_Active_Type))=0,1,Play_Active_Type) as flag
In expression :-
Flag={'1','unknown','other:specify'}
it's working fine.