How do you show % increased or decreased in the summary label?

Kailin · 2024-01-25T03:28:02+00:00

There was an error rendering this rich post.

Kailin

Find more posts tagged with

Accepted answers

DavidChurchman

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: https://domo-support.domo.com/s/article/360043430093?language=en_US

All comments

ColemenWilson

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.

Kailin

How can we show the green one (173.6% increase)?

ColemenWilson

((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.

Kailin

Hi Coleman,

I understand that beastmode but I want to show that green part… do you know how?

ColemenWilson

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?

Kailin

How can I show this?

Kailin

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 !!

ColemenWilson

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_VALUE

Kailin

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.

ST_Superman

That is just the chart type. It is called a sparked bar and is found in the "other charts" section:

ColemenWilson

@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 Bar

Kailin

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.

DavidChurchman

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: https://domo-support.domo.com/s/article/360043430093?language=en_US