Built in data table functionality & arrows
Hey guys. Weird ask here. Boss is wondering if I can make a visual that gets rid of the light blue bar (Revenue) but keep it in the data table below. Reason being is so I can have two scales for the values instead of the three, which is why the scale for the light grey bar is messed up. She is also asking for up and down arrows based on if the value went up or down from the previous month. Is this even possible in DOMO?
Best Answers
-
There are not many options to customize what is shown in the Data Table, your best bet would be to use two separate cards, one for the line and bar and another for the table that displays the data, and even then, having the arrows would require you to set your data for month over month comparison and most likely use a best mode to transform the calculation into a text that will the arrows. There are several threads in the forums that talk about how to do Period over Period different ways so one of those might help more.
0 -
I'd agree. Have two separate cards, one for the line + bar and the other for an HTML table where you can have up and down color-coded arrows.
Here's a post I did talking about architecting your data for PoP comparisons, which gives you more flexibility:
And here's another post about how to do custom colorization within a beast mode:
You can include a custom unicode character of an up or down arrow depending on the direction along with the color.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1 -
What's tricky about this is you have three completely different scales you're comparing, and it's difficult to visualize more then two different scales on the same 2-dimensional plane. I might suggest a faceted bar graph instead, which gives a more honest representation of three different scales than laying them on top of each other, and has the option of a data table.
Please 💡/💖/👍/😊 this post if you read it and found it helpful.
Please accept the answer if it solved your problem.
0
Answers
-
There are not many options to customize what is shown in the Data Table, your best bet would be to use two separate cards, one for the line and bar and another for the table that displays the data, and even then, having the arrows would require you to set your data for month over month comparison and most likely use a best mode to transform the calculation into a text that will the arrows. There are several threads in the forums that talk about how to do Period over Period different ways so one of those might help more.
0 -
I'd agree. Have two separate cards, one for the line + bar and the other for an HTML table where you can have up and down color-coded arrows.
Here's a post I did talking about architecting your data for PoP comparisons, which gives you more flexibility:
And here's another post about how to do custom colorization within a beast mode:
You can include a custom unicode character of an up or down arrow depending on the direction along with the color.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1 -
What's tricky about this is you have three completely different scales you're comparing, and it's difficult to visualize more then two different scales on the same 2-dimensional plane. I might suggest a faceted bar graph instead, which gives a more honest representation of three different scales than laying them on top of each other, and has the option of a data table.
Please 💡/💖/👍/😊 this post if you read it and found it helpful.
Please accept the answer if it solved your problem.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 298 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 54 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
- 33 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive