Charting
Charting
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:
Customer Support Community
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:
0 -
@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: Customer Support Community
Please π‘/π/π/π this post if you read it and found it helpful.
Please accept the answer if it solved your problem.
0
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
- 807 Beast Mode
- 80 App Studio
- 44 Variables
- 762 Automate
- 189 Apps
- 480 APIs & Domo Developer
- 75 Workflows
- 18 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 408 Distribute
- 119 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 142 Manage
- 138 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