can't graph by month

user06299
user06299 Member
in Archive

Why does the graph by option (day, month, year, etc) not always available? It just says none and cannot be changed. I'm using a date dimension in my X axis (YYYY-MM-DD) and numeric in my Y axis. What am I missing? I've never had this issue before.

 

 

Comments

  • Valiant
    Valiant Coach

    Does your date dimension have the calendar icon next to the name? Or is it being seen as a Text field?

    image.png

     

    You can also try creating a BeastMode using your date like this:

    CAST( `Date` AS Date`)

    Hope this helps,

    ValiantSpur

     

    **Please mark "Accept as Solution" if this post solves your problem
    **Say "Thanks" by clicking the "heart" in the post that helped you.

  • user06299
    user06299 Member

    Thanks for the speedy reply. Yep, it does show the date icon that you pointed out. Date 1.pngDate 2.png

  • Valiant
    Valiant Coach

    If you recreate the card from scratch, are you still unable to group? I've had to do that before to "re-enable" some of the default options that should be available.

  • user06299
    user06299 Member

    Tried a couple times to start from scratch. No luck. Thanks for trying

  • AS
    AS Coach

    Is that a drill path card or a top level card?  I've seen this behavior when it's a drill down, and we had to start that card from scratch in order to get it to work.  If it's a drill down, what date grain does the top level card have?

    Aaron
    MajorDomo @ Merit Medical

    **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"
This discussion has been closed.

Categories