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

image.png

Best Answer

  • KurtF
    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"

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"
  • Hi Kurt,

    Confirming it is a date field. 

    image.png

    Thanks!

  • Ah! Thanks so much. I used:

     

    DATE(CONCAT(left(`Dimension.MONTH_AND_YEAR`, 4), '-', right(`Dimension.MONTH_AND_YEAR`, 2), '-01'))

This discussion has been closed.