Stop including null values when sorting in reports

Related products: None

Something that’s been recently driving me nuts is that when you sort on a number field, the report builder shows null values first. This behavior makes no sense. 

 

For example, in this report, I’m trying to sort on “total accounts.” When I sort by fewest, I get the following, which is expected: 

However, when I reverse that sorting and therefore expect to see the highest number on down, I instead get all the null values first. This makes no sense!

 

I checked Excel just to make sure I wasn’t crazy. Here’s how Excel functions with null values - notice how null values aren’t considered. This is how Gainsight’s report builder should function too. 

 

@Azad, to put this on your radar.


Can we get an update on this? I feel like this would be relatively easy to fix.


@rakesh your thoughts on this?


Updated idea statusNo StatusAcknowledged

Updated idea statusNo StatusAcknowledged