Calculate one value against multiple values in different columns
Answers
-
if it were me i would unpivot the data (Magic ETL) to collapse the values in columns 2, 3, and 4 into one column then do a windowed MIN function with the Rank and Window tile.
If you don't want to restructure your data, you could see if Magic or Beast Modes have an implementation of the LEAST() function https://www.w3schools.com/sql/func_mysql_least.asp
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"3 -
@mHejl I think @jaeW_at_Onyx has a good suggestion for you. If that is not working out, it would be helpful if you showed some examples so that we can understand what your data looks like and what output you are trying to get to.
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman1
Categories
- All Categories
- 1.2K Product Ideas
- 1.2K Ideas Exchange
- 1.3K Connect
- 1.1K Connectors
- 273 Workbench
- 2 Cloud Amplifier
- 3 Federated
- 2.7K Transform
- 78 SQL DataFlows
- 525 Datasets
- 2.1K Magic ETL
- 2.9K Visualize
- 2.2K Charting
- 434 Beast Mode
- 22 Variables
- 510 Automate
- 114 Apps
- 388 APIs & Domo Developer
- 8 Workflows
- 26 Predict
- 10 Jupyter Workspaces
- 16 R & Python Tiles
- 332 Distribute
- 77 Domo Everywhere
- 255 Scheduled Reports
- 66 Manage
- 66 Governance & Security
- 1 Product Release Questions
- Community Forums
- 40 Getting Started
- 26 Community Member Introductions
- 68 Community Announcements
- 4.8K Archive