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 -
Ah! Thanks so much. I used:
DATE(CONCAT(left(`Dimension.MONTH_AND_YEAR`, 4), '-', right(`Dimension.MONTH_AND_YEAR`, 2), '-01'))
1
Categories
- 7.3K All Categories
- 13 Getting Started in the Community
- 134 Beastmode & Analytics
- 1.8K Data Platform & Data Science
- 52 Domo Everywhere
- 2K Charting
- 994 Ideas Exchange
- 894 Connectors
- 236 Workbench
- 342 APIs
- 76 Apps
- 18 Governance & Productivity
- 233 Use Cases & Best Practices
- 49 News
- 473 Onboarding
- 570 日本支部