Columns with 2 Unique Values (1,0), into one Column
Hoping someone can help me solve this.
I have a dataset that has multiple columns with a 0 or 1 value. I'm trying to combine these multiple columns into one using a beastmode, naming those values with their respective headers -
So:
(CASE
when `Business Change` = 1 then 'Business Change'
when `Division Change` = 1 then 'Division Change'
when `GL Department Change` = 1 then 'GL Department Change'
when `GL Business Unit Change` = 1 then 'GL Business Unit Code Change'
when `GL Operating Unit Change` = 1 then 'GL Operating Unit Change'
when `Job Code Change` = 1 then 'Job Code Change'
else 'Other' End)
-- The problem I am running into is that this beastmode is used for a year's worth of data. At the beginning of the year, you could have a division change, and at the end of the year, a job code change. This beastmode doesn't pull the last most current change - so instead of the job code change, it would pull the division change instead.
Is there a way to solve this problem? Or would it be better to fix the issue in another way? Thank you!
Comments
-
I'm assuming that your data set has a date field in it.
You could add some transforms in your dataflow that would call out the most recent change per employee. Then you could add that field to your beastmode.
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 297 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 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
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive