Beast Mode Numbers Sorting Improperly
Hi all - I create the folling simple beastmode to find the number of days between two dates:
DATEDIFF(`Date1`, `Date2`)
The formula validated and the output reflected the correct number of days between the two dates - great!
The problem is that the card that the beastmode is in does not seem to recognize the value of the number, even though the data type shows up as a number and falls under the "measures" category. When sorting, only the first number seems to matter - for instance, 1,000 comes before 2, and 2,000 comes before 3, etc. Does anyone know what could be causing this?
Comments
-
That is weird, I have a calculation like that sor sorting and it works fine.
all I can think of is , make sure 1) your beastmode is the first in the sorting box and it is set to no aggregation and 2) take a look at what else you are sorting the table (second, third ect level of sorting) and 3) make sure your dates are all dates and take in consideration if NULLS are present, either filter them out or modify your beastmode to assess for them
Domo Arigato!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'2 -
I am having the same issue. There is no other sorting levels and I am choosing "no aggregation". It still shows, in ascending order: 1 -11 - 12 -13 - 2 - 3 - 4...
1 -
Yup, still happening for me as well! I think it might be a bug because I tried everything above and nothing fixed it. Also it is happening on other cards with other variables.
0 -
I am going to share this thread with the support team to have a look, thanks!
2 -
is the beastmode Blue or Green when you add it to the sorting section
if blue = Text that explains the order 1, 11, 12, 13, 2, 3,
if green = its a number and should sort properly
Domo Arigato!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'1 -
It is green
1 -
@DaniBoy Any updates on this? I'm still dealing with this issue on the original card and now several others. Have checked that the measure is green, set to 'no aggregation', etc. but still numbers that lead with a smaller value are appearing before numbers that leader with a greater value. For example, 1359 is sorting ahead of 751 even though it is set to know aggregation + acsending. Also it may be worth mentioning that the values I am using come from a beast mode that is calculated using other numeric measures. Not sure if the beast mode origin could be a contributing factor in this bug. Thanks!
1 -
Hi, I finally called Domo help and they were able to find the issue. I was entering "error" after the last else and that is why it wasn't recognizing the whole calculation as a number. I changed it to -1 and the issue was fixed. Hope it works for you.
1 -
Thanks @ClaraS for sharing.
@PI_Science Can you see if Clara's recommendation helps you out? Please let us know.0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 299 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 54 App Studio
- 40 Variables
- 681 Automate
- 175 Apps
- 451 APIs & Domo Developer
- 46 Workflows
- 9 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 33 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive