Date format on YoY chart

LLucinski
LLucinski Member
in Charting

Hi - I have a Year over Year by quarter card, and I'd like to have the date format on the x-axis be the quarter number only, i.e. Q1, Q2, etc..  Instead, it defaults to the most recent year.  From the knowledge base, it appears that there used to be a macro, %Q, but that was discontinued in the latest release.  Can anyone help?  Thanks, LaurieQuarterly Chart example.PNG

 

Best Answer

  • Valiant
    Valiant Coach
    Answer ✓

    Laurie,

     

    I'm seeing the same thing on my end in regards to the date formats. There doesn't seem to be a working native format option to return only the quarter. 

     

    If that's the case, the only method would be to create a beastmode that returns the quarter # for your date range, something like:

    QUARTER(`date`)

    Then use that as your X axis and apply a sort on the `date` field in order to order them correctly. 

     

    You would then have to build out the fiscal year intervals for your values as well and use that as your Y axis values. 

     

    It might be worth reaching out to support though to see if there's a way to get the %Q function added back in.

     

    Best of luck,
    Valiant

Answers

  • Valiant
    Valiant Coach
    Answer ✓

    Laurie,

     

    I'm seeing the same thing on my end in regards to the date formats. There doesn't seem to be a working native format option to return only the quarter. 

     

    If that's the case, the only method would be to create a beastmode that returns the quarter # for your date range, something like:

    QUARTER(`date`)

    Then use that as your X axis and apply a sort on the `date` field in order to order them correctly. 

     

    You would then have to build out the fiscal year intervals for your values as well and use that as your Y axis values. 

     

    It might be worth reaching out to support though to see if there's a way to get the %Q function added back in.

     

    Best of luck,
    Valiant

  • LLucinski
    LLucinski Member

    Valiant - thanks for your reply.  I think I'll change it back to a monthly view!  But I will put in a suggestion to reinstate the quarterly function.  Thanks.

This discussion has been closed.

Categories