null value to sort to top

GenDemo
Participant V

Hi All

How can I get a null value to sort to the top?
In another visualisation where I have something similar, it sorts to the top… but not in this one.
Any ideas?

image

0 3 521
3 REPLIES 3

Hi @GenDemo,

By holding shift, you can define a multi-column sort order. So start by using a table calc to make an “Is Null?” yes/no column, sort first by that, then shift+click your main column to set it as the next sort.

Hope that works for your use case!

GenDemo
Participant V

Thnx!
great idea with the is_null() column.
The ‘Shft + click’ doesnt do anything for me, but it seems that if I just sort on the is_null() column, then my other column appears in order… just hope it is robust enough to stay that way.

image

GenDemo
Participant V

ok and immediately after I posted that, and closed the dashboard, it failed.
So, what I did was, edited my ‘sort_order’ table calc to:
if(is_null(weeks), -99, weeks)
and then hid that, and sorted on it. That works. 😃

Top Labels in this Space
Top Solution Authors