Sorting Fiscal Year Month

[#1]

Hi all

I have a line chart to calculate sales over financial year

Dimension- Month, Fiscal Year(Apr-Mar)

Expression- Sum(Sales)

My prob is I have month in my X axis showing from Jan to Dec but I want to sort it like Apr-Mar.

I have also seen some discussion in community its not working.

I attached the Image of the chart here for reference.

[PrashantSangle]

Hi,

How are creating Your Fiscal Month.

Use MonthName(DateField)  as NewMonth

Use NewMonth as your dimension and sort it in ascending.

Regards,

[maxgro · Accepted solution]

try to sort by expression (image)

match(Month, 'apr', 'mag', 'giu', 'lug','ago','set','ott','nov','dic','gen','feb','mar')

adaptmonth name to your setting

[#4]

I have 4 fiscal years

Since i am using month in x axis if i use monthname my values are like this Apr2012, Apr2013, Apr2014.

I have not calculated fiscal month

I have only fiscal Year like this YearName(VISIT_DATE, 0, 4) AS FiscalYear in Load

[PrashantSangle]

Hi,

Then Mossimo Suggestion Should Work

Regards,

[#6]

Its working perfectly

Thank you so much

Can you tell me what s the difference between math and wildmatch

[maxgro]

maybe also

if(Month<4, Month+12,Month)

[#8]

Hi,

Create a field as follows in your calender script

if (month(Date)<=$(FiscalMonthAdjust),month(Date)+(12-$(FiscalMonthAdjust)),month(Date)-$(FiscalMonthAdjust)) AS [Fiscal Month Num]

where FiscalMonthAdjust=3;and then in the Sort Tab of the chart properties,add [Fiscal Month Num] in the Expression option provided and dont forget to check the Expression option and unchecking the rest.

[MK_QSL]

Load

     *,

     If(Match(Name,'Vidhya'),1,0) as MatchFlag,

     If(WildMatch(Name,'*dhy*'),1,0) as WildMatchFlag

Inline

[

     Name

     Vidhya

     Annamalai

];

The match function performs a case sensitive comparison. 

The wildmatch function performs a case insensitive comparison and permits the use of wildcard characters ( * and ?) in the comparison strings.

[#10]

Thank you so much