Can you create a beastmode CASE when for values between two numbers?
I'm looking at influencers and their number of followers and want to group the data:
number of follower: 1-50000, 50000-100000, 100000-200000 and so on.
I was going to use the case when beastmode but cant find a between function to select the relevant numbers. Any help?
You sure can. Just modify this to your own use:
CASE WHEN `followers` BETWEEN 1 AND 50000 THEN 'A'
WHEN `followers` BETWEEN 50001 AND 100000 THEN 'B
Hopefully that's what youre looking for. If not, let me know and i'll try to help further.
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.0
Hi! This doesnt seem to work, is there something else wrong with the beastmode calculation?
CASE WHEN `Followers` BETWEEN 0 AND 9999 THEN 'Bronze'
WHEN `Followers` BETWEEN 10000 AND 99999 THEN 'Silver'
WHEN `Followers` BETWEEN 100000 AND 499999 THEN 'Gold'
WHEN `Followers` BETWEEN 500000 AND 1000000000 THEN 'Platinum'
What's the datatype for your `Followers` field? In the analyzer when you're doing the beastmode, what does the icon next to the field name look like? Is it a '123' like below?0
yes its '123' ?0
Hi, I'm also facing the same issue. I wanted to set the range of a metrics (datatype is '123'). Usually we show this metrics in a aggregated level (Sum). But the output of the beast mode is not showing correctly. Any solution for this?0
- 7.7K All Categories
- 5 Connect
- 921 Connectors
- 244 Workbench
- 477 Transform
- 1.8K Magic ETL
- 60 SQL DataFlows
- 446 Datasets
- 40 Visualize
- 199 Beast Mode
- 2K Charting
- 8 Variables
- 20 Cards, Dashboards, Stories
- 1 Automate
- 348 APIs & Domo Developer
- 82 Apps
- 14 Predict
- 3 Jupyter Workspaces
- 11 R & Python Tiles
- 241 Distribute
- 59 Domo Everywhere
- 241 Scheduled Reports
- 15 Manage
- 36 Governance & Security
- 28 Product Ideas
- 1.1K Ideas Exchange
- Community Forums
- 14 Getting Started
- 1 Community Member Introductions
- 49 Community News
- 18 Event Recordings
- 579 日本支部