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
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 7 Cloud Amplifier
- 9 Federated
- 3K Transform
- 114 SQL DataFlows
- 654 Datasets
- 2.2K Magic ETL
- 4.1K Visualize
- 2.5K Charting
- 803 Beast Mode
- 79 App Studio
- 44 Variables
- 758 Automate
- 188 Apps
- 480 APIs & Domo Developer
- 73 Workflows
- 17 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 408 Distribute
- 119 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 141 Manage
- 137 Governance & Security
- 8 Domo Community Gallery
- 47 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive