Date is changing from M/D/Y to the number week in the year.

Jeremy
Jeremy Member
in Charting

I have a grouped and stacked card that is showing revenue for the last 3 weeks.  I have the date filter set up to show last 3 weeks filtered by week.  However, the data format is showing the number of weeks in the year instead of the week start date that is in the actual data.  My column 'Week Start Date' has Sunday dates on it and I'd like the bar to show that instead of Week 38.

 

Details:

Week Start Date - 9/2/18 and 9/9/18

Showing:  Week 36 and Week 37

 

Thanks for the help.

Best Answer

  • Property_Ninja
    Property_Ninja Contributor
    Answer ✓

    If there is no data and dates are showing you should change CHART PROPERTIES --> CATEGORY SCALE (X) --> NEVER USE TIME SCALE to 'True'

     

    This should remove dates without values

     

    Brian


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

Answers

  • Property_Ninja
    Property_Ninja Contributor

    Hi Jeremy,

     

    You should just be able to change the "Graph by" to "None" and it should show your actual dates.

     

    Thanks,

     

    Brian

     

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


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

    I did try that as well thinking that may solve my issue but then I see all the dates.  I'd like it to just show the two dates with the amount of revenue for the week and not the whole month.  

  • Property_Ninja
    Property_Ninja Contributor

    So your date range says last 3 weeks and it's graphed by none but you are seeing more than three weeks?

     

    Can you send a screenshot of your example?


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

    If there is no data and dates are showing you should change CHART PROPERTIES --> CATEGORY SCALE (X) --> NEVER USE TIME SCALE to 'True'

     

    This should remove dates without values

     

    Brian


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

    This worked.  I misread that and applied false but true cleared it up.  Thanks for the help.

  • MackDaddy
    MackDaddy Member

    In order to get week over week you have to graph by week.  The only problem it shows the week numbers like it was stated.  If I select graph by none, then no data appears - I also enabled the setting to True.

    Any idea why it's not working.... thinking it's not possible with week.

    See screenshot below

This discussion has been closed.

Categories