Display Numeric Value on Radial Gauge Chart

user06488

Is there a way to add a data label on a radial gauge chart, so users can see the numeric value without hovering? On some cards I've been able to display the value as the Summary Number, but I can't see how to do that if the value is a beast mode calculation. Also, I would sometimes like to use the Summary Number to display something besides the charted value, and still see in addition the value itself somewhere on the card without hovering. 

Godiepi

A work around would be to build a beastmode to use as your summary number using a Concat() function

this way you can have more than just one metric displaying and adding some HTML formatting  to differentiate one thing to another

 

JacobFolsom

Good call out @Godiepi .

 

I would also recommend looking into bullet graphs as a visual alternative. You can configure data labels for each section. This works well when you need visualize single or multiple categories and plot actuals vs target vs range values. Also, notice the summary number which uses the referenced concat() function to provide a narrative of two metrics not plotted in the chart.

 

In my case below, I'm looking at a metric compared to last year and a range of milestone goals. I want to see the blue bar progressing past the red goal indicator.

 

Godiepi

---

answers in RED below

@user06488 wrote:

That looks like a great solution to my issue, Godiepi (thanks!), but I can only see Measures, not Dimensions, in the "Field & Function" list when configuring the Summary Number "That is correct, it depends what you would like to show, for example the radial value is a meassure coming from a calculation, if not it can become a calculation just by multiplying by 1", and the only beastmodes Measures that show up are ones that have aggregation functions (such as AVG). Is there some trick to getting the beastmode that uses CONCAT() to show up in that list to choose from? "Yes , it has to come from the result of an aggregation,  it would be good to know what fields are you working with and what are you expecting for the final result... I am just trying to blind guess ? "

 

Also,  can you please explain what the "call out" box in the upper right corner of your screenshot is and how you created it? Is it a Notebook card or something? "Oh, I screenshoted a rectangle for a completetly different card , only to give you a visual of formating a summary with HTML , fonts changing green vs gray or red depending of the value aggregated"

 

Thanks in advance! 

---

 

JacobFolsom

Great suggestion. We currently do not have this option. Please submit this to the Dojo Ideas Exchange http://dojo.domo.com/t5/Ideas-Exchange-suggest-and-vote/idb-p/Ideas.

 

There are some exisiting requests for radial gauges, mostly around dynamic ranges instead of hard coded labels, as you mentioned with the beastmode solution to generate a target. I think your suggestion would be an improvement to offer more control around data label display options. 

Godiepi

A work around would be to build a beastmode to use as your summary number using a Concat() function

this way you can have more than just one metric displaying and adding some HTML formatting  to differentiate one thing to another

 

JacobFolsom

Good call out @Godiepi .

 

I would also recommend looking into bullet graphs as a visual alternative. You can configure data labels for each section. This works well when you need visualize single or multiple categories and plot actuals vs target vs range values. Also, notice the summary number which uses the referenced concat() function to provide a narrative of two metrics not plotted in the chart.

 

In my case below, I'm looking at a metric compared to last year and a range of milestone goals. I want to see the blue bar progressing past the red goal indicator.

 

user06488

That looks like a great solution to my issue, Godiepi (thanks!), but I can only see Measures, not Dimensions, in the "Field & Function" list when configuring the Summary Number, and the only beastmodes Measures that show up are ones that have aggregation functions (such as AVG). Is there some trick to getting the beastmode that uses CONCAT() to show up in that list to choose from?

 

Also,  can you please explain what the "call out" box in the upper right corner of your screenshot is and how you created it? Is it a Notebook card or something?

 

Thanks in advance! 

user06488

DataJake - Thanks for the Bullet Graph suggestion. That might also work nicely for me, I will look into them.

Godiepi

---

answers in RED below

@user06488 wrote:

That looks like a great solution to my issue, Godiepi (thanks!), but I can only see Measures, not Dimensions, in the "Field & Function" list when configuring the Summary Number "That is correct, it depends what you would like to show, for example the radial value is a meassure coming from a calculation, if not it can become a calculation just by multiplying by 1", and the only beastmodes Measures that show up are ones that have aggregation functions (such as AVG). Is there some trick to getting the beastmode that uses CONCAT() to show up in that list to choose from? "Yes , it has to come from the result of an aggregation,  it would be good to know what fields are you working with and what are you expecting for the final result... I am just trying to blind guess ? "

 

Also,  can you please explain what the "call out" box in the upper right corner of your screenshot is and how you created it? Is it a Notebook card or something? "Oh, I screenshoted a rectangle for a completetly different card , only to give you a visual of formating a summary with HTML , fonts changing green vs gray or red depending of the value aggregated"

 

Thanks in advance! 

---

 

user06488

Got it to work! As you indicated, in my beastmode calculated field, I had to first aggregate my number, then wrap that in a CONCAT() function. The resulting calculated field then showed up in the list to choose from for a Summary Number, even though it's a "Dimension". Thank you!