Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
got a pivot table in which the expression groups results under null (something correct)
Handling label of labels and sorting of null dimension values
now what I want is to display the row with null value at the end (bottom of the chart) and give it a label Not Submitted
I want primarily to display the record at the bottom so that the cumulative percentage is well displayed
I tried several ways but couldn't reach a solution
Kindly advise
Are you creating this dimension in the script?
If you cannot modify the code, you can try to use coalesce(yourfield,'Not submited') as a dimension.
Hello Vincent
didn't work
you mean I use the coalesce function in the Dimensions on the chart no?
Yes.
But it depends of your datamodel or the expression your are using. Could you modify the loading script? If this is the case, this is better to replace the NULL value there.
Try to handle null values in backend
Else use calculated dimension like
If(isnull(field) or trim(Len(field)) =0, 'Not Assigned', field)
The null values come from the result of the expression used
Which contains a union n the set analysis (count expression)
So part of the result comes under the brackets, and the remaining are classified as nulls
Both approaches suggested above (calculated dimension / coalesce) not working