Question

How to get null values sorted to bottom?

  • 27 September 2021
  • 1 reply
  • 16 views

I’m trying to sort a table in explore in descending order from a column. The problem is that the Null values are set above the actual non null values. How do I send them to the bottom?

 

I tried to use COALESCE() and convert the values to zero. It’s successful in displaying it but I’m merging different table so in the merge preview, it doesn’t appear as 0.

 

Column being sorted on

 


1 reply

Userlevel 6
Badge

Some info here: 

 

Reply