Adding annotations to a line or bar graph
Hi,
I have a line graph that I'd like to add an annotation / text bubble to for the purpose of giving an example of why there's a spike. I'd like to tie it specifically to that spike so that as the data continues to grow, the annotation will stick with the spike. The "annotation" option appears to be greyed out for me on the ribbon. Do you know why that is?
Thanks!
E
Best Answer
-
It doesn't look like that is actually a date field. If it is concatenanted month and year then the Analyzer will not treat it as a date. You will need to write a BeastMode to format this as a date (which might be a little tricky). It would look something like this:
DATE(
CONCAT(LEFT(`Dimension.MONTH_AND_YEAR`,2), '-01-', RIGHT(`Dimension.MONTH_AND_YEAR`,4))
Then drag this BeastMode into the x-axis and then Annotation menu should be enabled.
KurtF
**Say “Thanks” by clicking the “heart” in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"2
Answers
-
In order to do annotations the x-axis has to use a date value. Most often when the Annotations option is grayed out it's because you're not using a date field. Can you confirm the data types being used in your card?
KurtF
**Say “Thanks” by clicking the “heart” in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"2 -
Hi Kurt,
Confirming it is a date field.
Thanks!
1 -
It doesn't look like that is actually a date field. If it is concatenanted month and year then the Analyzer will not treat it as a date. You will need to write a BeastMode to format this as a date (which might be a little tricky). It would look something like this:
DATE(
CONCAT(LEFT(`Dimension.MONTH_AND_YEAR`,2), '-01-', RIGHT(`Dimension.MONTH_AND_YEAR`,4))
Then drag this BeastMode into the x-axis and then Annotation menu should be enabled.
KurtF
**Say “Thanks” by clicking the “heart” in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"2 -
Ah! Thanks so much. I used:
DATE(CONCAT(left(`Dimension.MONTH_AND_YEAR`, 4), '-', right(`Dimension.MONTH_AND_YEAR`, 2), '-01'))
1
Categories
- 10.6K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 477 Transform
- 1.8K Magic ETL
- 69 SQL DataFlows
- 478 Datasets
- 218 Visualize
- 260 Beast Mode
- 2.1K Charting
- 12 Variables
- 19 Automate
- 356 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 249 Distribute
- 65 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 191 Product Ideas
- 1.2K Ideas Exchange
- 11 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive