How do you show % increased or decreased in the summary label?
Best Answer
-
It is not possible to add an x-axis to the Spark Bar (maybe suggest this in the idea exchange?). Alternative:
- You could add it as part of your data label.
- You could also use the Flex Table, which allows has the same change indicators, but gives more options for labeling the graph.
- You could achieve a similar summary number on a standard bar chart (where you're actually allowed to have an x-axis). You could do it with HTML formatting and Unicode characters like 🡵 and 🡶. Here's an article with some examples of HTML formatting:
Please 💡/💖/👍/😊 this post if you read it and found it helpful.
Please accept the answer if it solved your problem.
0
Answers
-
To show a % change in a summary number, you'll need to calculate the % change in a beastmode (calculated field). Once you have created the beastmode, you can select it as your summary number value.
If I solved your problem, please select "yes" above
0 -
How can we show the green one (173.6% increase)?
0 -
((Last Value - First Value) / First Value) * 100
I don't know the structure of your dataset or what represents your first and last values, but you'll need to create the above logic in a beastmode.If I solved your problem, please select "yes" above
0 -
Hi Coleman,
I understand that beastmode but I want to show that green part… do you know how?
0 -
Do you mean can you make a summary number green? Or how do you create a summary number? The green part is showing already, do you want it to show somewhere else?
If I solved your problem, please select "yes" above
0 -
How can I show this?
0 -
I can make a beastmode and get the %. But my question is how to show that arrow (increase) and also when you hover the mouse, you can see the first value and the last value? thank you !!
0 -
Oh I see, this screenshot is not from something you've made. You are trying to recreate it. Here are the steps:
1. Chart Types > Gauges > Multi-value Columns
2. Set a gauge value
3. Set a comparison value
4. Properties > Change Value Options > Value > Percent Change
5. Properties > Change Value Options > Hover Text > Current Value: %_VALUE
Previous Value: %_COMPARISON_VALUEIf I solved your problem, please select "yes" above
0 -
Hi Coleman,
Yes Coleman, I am sorry I didn't make that card. I want to show that in the summary number position but not as the main chart.
0 -
That is just the chart type. It is called a sparked bar and is found in the "other charts" section:
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman0 -
@Kailin Ah, yes with the full screenshot I see that that is a different chart type called Spark Bar as @ST_-Superman-_ pointed out.
Chart Types > Other Charts > Spark BarIf I solved your problem, please select "yes" above
0 -
Is there a way I can show an X-axis label in this type of chart? I want to show the fiscal year on the x-axis.
0 -
It is not possible to add an x-axis to the Spark Bar (maybe suggest this in the idea exchange?). Alternative:
- You could add it as part of your data label.
- You could also use the Flex Table, which allows has the same change indicators, but gives more options for labeling the graph.
- You could achieve a similar summary number on a standard bar chart (where you're actually allowed to have an x-axis). You could do it with HTML formatting and Unicode characters like 🡵 and 🡶. Here's an article with some examples of HTML formatting:
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.5K Product Ideas
- 1.5K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 280 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.7K Transform
- 90 SQL DataFlows
- 562 Datasets
- 2K Magic ETL
- 3.4K Visualize
- 2.3K Charting
- 586 Beast Mode
- 13 App Studio
- 28 Variables
- 585 Automate
- 142 Apps
- 415 APIs & Domo Developer
- 27 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 361 Distribute
- 99 Domo Everywhere
- 260 Scheduled Reports
- 2 Software Integrations
- 94 Manage
- 91 Governance & Security
- 9 Product Release Questions
- Community Forums
- 37 Getting Started
- 28 Community Member Introductions
- 89 Community Announcements
- 4.8K Archive