Repeated x-axis values

[#1]

Hi,

My x-axix values are repeated for the twpo esxpressions as shown in the attachment.

I wanted to see this once for both the expressions.

Thx.

Thejo,

[kaushiknsolanki]

HI,

     How you have created Fiscal Month?

     Kindly share the script.

Regards,

Kaushik Solanki

[#3]

Set vFirstMonthOfFiscalYear = 11;

Load distinct *,

if(CMonth>FMonth, (CYear+1),  CYear) as FiscalYear;

Load *,

          Mod(CMonth-$(vFirstMonthOfFiscalYear),12) as FMonth;

Load

          [Created Month],

          Year([Created Month]) as CYear,

          Month([Created Month]) as CMonth,

          week([Created Month]) as CWeek,

          Date(MonthStart([Created Month]),'MMM') as FiscalMonth,

          'Q'& ceil(Month([Created Month])/3) as CQuarter,

                    'Q'&

                    If(Match(Month([Created Month]),'Nov','Dec','Jan') > 0 , 1,

                    If(Match(Month([Created Month]),'Feb','Mar','Apr') > 0 , 2,

                    If(Match(Month([Created Month]),'May','Jun','Jul') > 0 , 3,

                    If(Match(Month([Created Month]),'Aug','Sep','Oct') > 0 , 4)))) AS FiscalQuarter

Resident tablename;