Repeated x-axis values

Wed, 24 Jul 2013 07:11:06 GMT

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,

Re: Repeated x-axis values

kaushiknsolanki — Wed, 24 Jul 2013 07:20:24 GMT

HI,

How you have created Fiscal Month?

Kindly share the script.

Regards,

Kaushik Solanki

Wed, 24 Jul 2013 07:23:50 GMT

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;