Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Hi,
How are creating Your Fiscal Month.
Use MonthName(DateField) as NewMonth
Use NewMonth as your dimension and sort it in ascending.
Regards,
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
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
Hi,
Then Mossimo Suggestion Should Work
Regards,
Its working perfectly
Thank you so much
Can you tell me what s the difference between math and wildmatch
maybe also
if(Month<4, Month+12,Month)
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.
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.
Thank you so much