4 Replies Latest reply: Mar 4, 2013 3:41 PM by jameshuk RSS

    Week/Year for X-Axis

      Hi:

       

      Can't seem to find a previous discussion on this. I currently have a variable created in the script to give me YEAR_MONTH

      Which works great. Seeking to do the same to add to a Cyclic Group dimension for a series of charts and thought I was home free with this, which loads without error: 

       

      date(WeekStart(APPROVED_DATE),'WW-YY')) as APP_YEARWEEK

      But the resulting field shows me, which looks right except for the 00.

      3-4-2013 3-34-09 PM.png

      Document format is

      3-4-2013 3-36-43 PM.png

      What am I missing?

      thanks in advance.

       

      Jim