Bucket Ordering
Hi,
I am working with pricing buckets of home loans. I have created two case statements. One that puts each loan id into a piricing bucket based on the loan amount. the second is to order those buckets in what would be numerical order.
I am getting a graph that, when the bucket order is being applied, doesnt want to bucket some of the loans in the proper buckets.
Here is what I am seeing.
Without sorting:
With sorting:
I need to sort them - to make it more like a histogram but I cannot have them out of order. When we apply the ordering, for some reason the buckets want to be broken out.
Any ideas?
If this helps, feel free to agree, accept or awesome it!
Best Answers
-
Your sorting is showing up as a string. Try changing your beast mode to = 1 if it's currently = '1'. If that doesn't work you may need to apply some aggregation in your beastmode bucketing or on the sort column to get the data to roll up in the correct bucket.
1 -
@damen It looks like you are sorting on something other than your 'Pricing Buckets' which is causing the problem. You will need to sort on your pricing buckets for it to work. You will probably need to create another beast mode called something like 'Pricing Buckets Sort' which would be exactly like your 'Pricing Buckets' beast mode but instead of the bucket names would just be 1, 2, 3, etc. Then use that for your sort.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**
1
Answers
-
Your sorting is showing up as a string. Try changing your beast mode to = 1 if it's currently = '1'. If that doesn't work you may need to apply some aggregation in your beastmode bucketing or on the sort column to get the data to roll up in the correct bucket.
1 -
@damen It looks like you are sorting on something other than your 'Pricing Buckets' which is causing the problem. You will need to sort on your pricing buckets for it to work. You will probably need to create another beast mode called something like 'Pricing Buckets Sort' which would be exactly like your 'Pricing Buckets' beast mode but instead of the bucket names would just be 1, 2, 3, etc. Then use that for your sort.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**
1
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 602 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 695 Beast Mode
- 43 App Studio
- 39 Variables
- 658 Automate
- 170 Apps
- 441 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 386 Distribute
- 111 Domo Everywhere
- 269 Scheduled Reports
- 6 Software Integrations
- 113 Manage
- 110 Governance & Security
- 8 Domo University
- 30 Product Releases
- Community Forums
- 39 Getting Started
- 29 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive