6 Replies Latest reply: Jan 31, 2015 12:52 PM by neetha P RSS

    How to Display January as Jan

    Jason Koczeniak

      Hello,

       

      I have a lot of data coming in with Months as January, February, March, etc...  In an effort to save a little space on my charts I would like to display these months as Jan, Feb, Mar, etc...

       

      I have left the default Set values in place but I cannot seem to figure out how to use these.

       

      Currently my data in loading from a QVD and looks like this:

       

      SET ThousandSep=',';

      SET DecimalSep='.';

      SET MoneyThousandSep=',';

      SET MoneyDecimalSep='.';

      SET MoneyFormat='$#,##0.00;($#,##0.00)';

      SET TimeFormat='h:mm:ss TT';

      SET DateFormat='M/D/YYYY';

      SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

      SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

      SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

       

       

      Directory;

      LOAD Segment,

           Month,

           Year,

           [Segment Monthly Cost],

           Fail,

           Pass,

           Remediated,

           [Complete by Target],

           [Complete by Original],

           [Projects not complete],

           [Budget of not complete],

           [BV of not complete],

           [Projects complete],

           [Budget of completed],

           [BV of completed],

           [Microsoft Patch %],

           [3rd Party Patch %],

           [AV Compliance],

           Total_Team_Member,

           Total_IT_Team_Member,

           Total_Contractor,

           Voluntary_Turnover,

           [# of Recordables],

           [# of Lost Days],

           [Total Lost Time]

      FROM

      ITDashboard_AllJoin.qvd

      (qvd);

       

       

       

      Can someone offer me some advice on how to convert these Months to display in three letters rather than the full name?