5 Replies Latest reply: Feb 14, 2016 2:51 PM by patrico mesri Branched from an earlier discussion. RSS

    Fiscal year - Order Months in line chart

    patrico mesri

      Can anyone help me with this same problem?

       

      This is my calendar:

       

      Calendar:

      DECLARE FIELD DEFINITION TAGGED '$date'

      Parameters

      first_month_of_year = 1

      Fields

      Year($1) As Year Tagged '$year',

      Month($1) as Month Tagged '$month',

      Num(Month($1)) as MonthNum Tagged '$month',

      Date($1) as Date Tagged ('$date', '$day'),

      Week($1) as Week Tagged '$week',

      Weekday($1) as Weekday Tagged '$weekday',

      DayNumberOfYear($1, first_month_of_year) as DayNumberOfYear Tagged ('$numeric');

       

       

      DERIVE FIELDS FROM FIELDS "Fecha Registro" USING Calendar;

       

      I don't understand how and where to put the script to make my bar charts show data in the following order:

       

      July, August , September, October , November, December , January, February , March, April , May, June


      Thank you.

      Regards.