Sorting question, why are values of zero counted highest?
Hi,
I am sorting a table of highest to lowest based on yearly sales.
An issue I have is that sales reps with 0 sales are always sorted to the highest position. This is annoying because I am unable to place them at the bottom, even by creating beast modes.
I am not sure how to exclude them from the data set I would either like to do that or to sort them to the proper position.
Thanks!
Comments
-
Domo has a really hard time with null values. It's actually not really specific to Domo - null values should be avoided whenever possible in datasets.
You didn't specifically say that the actual values are null, but I am making that assumption based on really common challenges encountered by all of us.
In your dataflow, you want to use the mapping feature on the field which contains the sales figure. Where the value is null, you want it to populate a 0. For good measure, you can also add the same for cases where it's a blank string. It only takes a couple seconds and covers your bases.
This will also make it possible to add criteria to exclude those with 0 sales.
DataMaven
Breaking Down Silos - Building Bridges
Check out my video!
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
@deefalcon - Did this solve your issue? Been a while, but want to make sure the solution gets in if it helped you. Thanks!
DataMaven
Breaking Down Silos - Building Bridges
Check out my video!
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Categories
- 10.8K All Categories
- 3 Private Company Board
- 1 APAC User Group
- 12 Welcome
- 39 Domo News
- 9.7K Using Domo
- 1.9K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 343 Workbench
- 260 Domo Best Practices
- 11 Domo Certification
- 465 Domo Developer
- 50 Domo Everywhere
- 106 Apps
- 717 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 27 お知らせ
- 64 Kowaza
- 299 仲間に相談
- 654 ひらめき共有