Use ETL to make calculated column a measure
Hi there
I had a measure of DELAY expressed in words in my input file. This cannot be changed by me.
I used beast mode to create a new column with the word changed to a number and I called this column DELAY2
However, this column is still be treated as a dimension
And if i open workflow to change this in ETL, the calculated column does not appear on the list of columns to be selected
--Any ideas how to use this of some other process to get DELAY to be a measure
Best Answer
-
At the end of your DELAY2 beast mode, multiply the entire thing by 1.
For example
(case when `DELAY` = 'One' then 1 when `DELAY` = 'TWO' then 2 end) *1
Domo Arigato!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'3
Answers
-
@user060210 - It's treating it as a measure because it's not an actual number. If you do have a textual representation of a number you'll need to use the Set Column Type tile to convert it from Text to either Whole Number or Decimal. Then the card should treat it as a metric and not a dimension. As this would have to be done before the beast mode is performed on the card you'd need to translate your beastmode to some additional ETL tiles to convert the word representation to numerical representation first.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
At the end of your DELAY2 beast mode, multiply the entire thing by 1.
For example
(case when `DELAY` = 'One' then 1 when `DELAY` = 'TWO' then 2 end) *1
Domo Arigato!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'3 -
I can set entries like 'immediate' 'delayed' to be a number because it is not clear what number that would be unless I specify it. That's why I created DELAY2
0 -
Thank you -- such a simple solution! Much appreciated.
1
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