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
- 300 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 738 Beast Mode
- 57 App Studio
- 40 Variables
- 685 Automate
- 176 Apps
- 452 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 124 Manage
- 121 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive