Forum Discussion

jcastr02's avatar
jcastr02
Icon for Post Prodigy rankPost Prodigy
4 years ago

clustered column chart - date hierarchy

Using a clustered column chart.  When I pull in a Date field into Axis - I can see all date hierarchy options available, Day, Month, Quarter, Year.  However, when I pull the same date field into the legend field, the date Hierarchy defaults to only show Year.  Is there a way around this?  Looking to put this field in Legend and show months.

 

Need Help

3 Replies

  • KNP's avatar
    KNP
    Icon for Super User rankSuper User
    4 years ago

    From your date hierarchy, expand and just drag the year to the legend.

    See gif below.

     

  • jcastr02's avatar
    jcastr02
    Icon for Post Prodigy rankPost Prodigy
    4 years ago

    Thanks KNP   is there a way for it to show the year as well - something like 21Jan, 21Feb   (or anythign similar)

    • KNP's avatar
      KNP
      Icon for Super User rankSuper User
      4 years ago

      Create a 'year-month' column in your data and add that to your date hierarchy.