how can i create a calculated field based off buckets?
Hi all,
Recently I created pricing buckets for the amount of loan a borrower took out. This works
Right now, we have two different visuals that show 2021 vs 2022
This is ok but we would rather be able to see both of these graphs in one with the different years in different colors. Is there any way to do this?
The only way I know how to set up a period over period visualization is with the year on the x axis - which in this case doesn't work.
If this helps, feel free to agree, accept or awesome it!
Best Answer
-
Wrap your beast mode in a case statement to check for this year and then another to check for last year
This Year Count:
CASE WHEN YEAR(`Fiscal Date`) = YEAR(CURDATE()) THEN COUNT(`Field`) END
Last Year Count:
CASE WHEN YEAR(`Fiscal Date`) = YEAR(CURDATE())-1 THEN COUNT(`Field`) END
You can then put both of these beast modes as your y value / series values and make sure you select a group type bar chart.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Answers
-
Wrap your beast mode in a case statement to check for this year and then another to check for last year
This Year Count:
CASE WHEN YEAR(`Fiscal Date`) = YEAR(CURDATE()) THEN COUNT(`Field`) END
Last Year Count:
CASE WHEN YEAR(`Fiscal Date`) = YEAR(CURDATE())-1 THEN COUNT(`Field`) END
You can then put both of these beast modes as your y value / series values and make sure you select a group type bar chart.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
The 'graph by' setting is set to graph by year. Not sure why the output is like that.
If this helps, feel free to agree, accept or awesome it!
0 -
I don't think you want 'graph by' since it's not really a time series. You're using the year as a categorical variable and applying it as the series value. I would get rid of the 'graph by', and then double check your sorts
Please 💡/💖/👍/😊 this post if you read it and found it helpful.
Please accept the answer if it solved your problem.
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 709 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive