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 -
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!
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
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 472 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 203 Visualize
- 255 Beast Mode
- 2.1K Charting
- 12 Variables
- 84 Cards, Dashboards, Stories
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 182 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive