Data Labels on Charts
Best Answers
-
@lfaulkner did any of the above replies help you? If so please mark the correct reply by clicking on "Accept as Solution".
Thanks!
Dani
2 -
You can see the available macros by clicking into the "Text" field in the "Data Label Settings" options.
Also, you can get explanations of the macros in the Help Center under the topic "How do I format data label and hover text?" Here's the text as it currently reads:
Macro
Description
%_CATEGORY_NAME
The name of the category that the data item belongs to
%_CATEGORY_NUMBER
The number of the category that the data item belongs to
%_CATEGORY_TOTAL
The sum of all the data values in the category that the data item belongs to
%_GRAPH_TOTAL
The sum of all the values in the graph
%_PERCENT_OF_CATEGORY
The data value represented as a percentage of the sum of all the data values in the category
%_PERCENT_OF_TOTAL
The data value represented as a percentage of the sum of all the data values in the graph
%_SERIES_NAME
The name of the data series that the item belongs to
%_SERIES_NUMBER
The number of the data series that the item belongs to
%_VALUE
The value of the data item
4 -
To make a data label show when the value is zero, there is actually a checkbox further down in the Data Labels section. Check that box and the value should show:
Hope this helps,
ValiantSpur
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.2
Answers
-
You can indeed add the count or absolute number. You can do this by going into the Chart Properties, selecting the "Data Label Settings", and then inputting these two macros %_PERCENT_OF_TOTAL (%_VALUE) into the "Value" category. There are 9 total macros available for use in this "Value" field. You can also use these macros in the "Hover Text Settings" "Value" field as well.
**Say “Thanks" by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"5 -
@lfaulkner did any of the above replies help you? If so please mark the correct reply by clicking on "Accept as Solution".
Thanks!
Dani
2 -
Where can I find the info on those 9 macros for value field? It's really useful but I may forget how to use them in the future..
0 -
You can see the available macros by clicking into the "Text" field in the "Data Label Settings" options.
Also, you can get explanations of the macros in the Help Center under the topic "How do I format data label and hover text?" Here's the text as it currently reads:
Macro
Description
%_CATEGORY_NAME
The name of the category that the data item belongs to
%_CATEGORY_NUMBER
The number of the category that the data item belongs to
%_CATEGORY_TOTAL
The sum of all the data values in the category that the data item belongs to
%_GRAPH_TOTAL
The sum of all the values in the graph
%_PERCENT_OF_CATEGORY
The data value represented as a percentage of the sum of all the data values in the category
%_PERCENT_OF_TOTAL
The data value represented as a percentage of the sum of all the data values in the graph
%_SERIES_NAME
The name of the data series that the item belongs to
%_SERIES_NUMBER
The number of the data series that the item belongs to
%_VALUE
The value of the data item
4 -
This is awesome. Thanks!
0 -
Is there any way to make the value 0 appear on the chart. i.e I selected %_VALUE as my Text, but if the value is zero it doesnt show up on the card. Is there a way I can fix this?
1 -
To make a data label show when the value is zero, there is actually a checkbox further down in the Data Labels section. Check that box and the value should show:
Hope this helps,
ValiantSpur
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.2 -
Yeah, I'm not seeing it listed there under funnel. I'm not even sure how that would look if you're showing a 0 value on a funnel
If that's something that would be helpful for you, you can log it and detail what you want in the Ideas Exchange here:
https://dojo.domo.com/t5/forums/postpage/board-id/Ideas
If you can get some support (upvotes) behind your idea, they may add it in a future release.
Sincerely,
ValiantSpur
0 -
@user04417 great find! Best of luck
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 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
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive