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.5K Product Ideas
- 1.5K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 278 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.7K Transform
- 89 SQL DataFlows
- 560 Datasets
- 2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 575 Beast Mode
- 13 App Studio
- 28 Variables
- 584 Automate
- 142 Apps
- 415 APIs & Domo Developer
- 26 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 356 Distribute
- 95 Domo Everywhere
- 259 Scheduled Reports
- 2 Software Integrations
- 92 Manage
- 89 Governance & Security
- 9 Product Release Questions
- Community Forums
- 42 Getting Started
- 28 Community Member Introductions
- 89 Community Announcements
- 4.8K Archive