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.