Creating a case statement based on Row Header
Hi,
Would it be possible to create a case statement that basically looks at the row label and then takes the variance of the two? For example One column at the end called variance and for loads it takes the variance and for MPL it takes the variance etc.
Best Answer
-
You can accomplish this with a Flex Table chart type. You can probably just change the chart type to flex without needing to rearrange any of the columns. You'll then need to adjust the "column definitions" and "change value options" in chart properties to get the variance totals you're wanting.
1
Answers
-
I essentially just want the total row to be the difference between the two.
0 -
You can accomplish this with a Flex Table chart type. You can probably just change the chart type to flex without needing to rearrange any of the columns. You'll then need to adjust the "column definitions" and "change value options" in chart properties to get the variance totals you're wanting.
1 -
jessdoe That's closer that what I'm looking for. The only thing I have a question on is how do I get the months names in there?
Here is what I currently have. Instead of Chart I would like Previous month(above the second Column) and current month(above the third). I tried to switch the column name under column definition but that didnt work.
0 -
I guess you had to be looking at the dashboard to see the names of the columns. Thank you for your help!
1
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
- 678 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 46 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