date formatting problems

DennisL
DennisL Member
in Archive

I'm having trouble formatting the date on my card. I have a date grain selected and date is in my X-axis. it is currently showing as 2016-Mar and I'd like it to say Mar-2016. I was able to get it working on one card after several tries, but I' not having luck with any more cards. both cards use the same dataset, and the field is a date field formatted as 3/1/2016. you can see from the attached pcture that i've got the x-axis formatted the way I think it should be(the way the working card is set up) but the graph is still showing the default formatting. Any help would be appreciated. 

Comments

  • AS
    AS Coach

    Leave that formatting in place, but switch your date aggregation around, to day for example instead of month, and see if that helps.  Experiment to see what works.

    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"
  • DennisL
    DennisL Member

    so are you saying that perhaps my data field is the problem, and this is not a bug? 

  • AS
    AS Coach

    No, I think the card isn't behaving the way it should but you might be able to get around the issue by tinkering with other settings.  

    I observed the same problem on one of my cards but was able to resolve it by using the special formatting but changing the date level from day to month.

     

    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"
  • DennisL
    DennisL Member

    I'm now going the route of one of Godzilla's postings where you just make a beast mode with date_format and I just use that as my x-axis. Thanks!

This discussion has been closed.

Categories