Start chart from April

[sifatnabil]

Hi all,

How can I have a chart with Month as Dimension start from April instead of January? Since this is the UK tax year, it starts from April. Thanks.

[alexandros17]

if you have month in dimension (e.g.: yyyymm -> 201401 for jabuary 2014) you may write as modified dimension:

if(myMonth >= 201403, muMonth, null()) and exclude null values

[senpradip007]

try like this:

SET MonthNames='Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec;Jan;Feb;Mar';

in Main tab of ypur script.

[yduval75]

in your expression :

Sum ({<Month={>=4}>} Data)

[rustyfishbones]

Hi,

You could try changing the SET in the Main Tab like

[#6]

In your model generate Monthnum for each month

Ex:

Map1:

Load * Inline [

Month, MonthNum

Apr, 1

May, 2

Jun, 3

Jul, 4

,

,

,

Mar, 12

];

YourTable:

Load *,

Applymap('Map1',Month) as MonthNum

From Yoursource;

After getting this column from your script do this,

Chart Dimenssion(Month) -> Sort expression ->=Only({1}MonthNum)

[#7]

Update:

In UI:

Use this in Chart Dimension(Month) sort expression

=Wildmatch(Month,'Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec','Jan','Feb','Mar')

[sifatnabil]

Thanks, this works half way - The chart starts from April 2013, but after December 2013, it shows the sum for Jan 2013 instead of Jan 2014, thus showing a misleading figure. Is there a way to have the chart go from April 2013, May 2013.......Dec 2013, Jan 2014, Feb 2014, Mar 2014?

My graph looks like this after using your method (and full accumulation turned on):

I'm basically trying to get the chart to look like this, but with it starting from April:

[#9]

In the expression use filter for the year like

=Sum({<Year={$(=Max(FinancialYear))}>}Sales) or

=Sum({<Year={'$(=Max(FinancialYear))'}>}Sales)  or

vMaxFinancialYear = Max(FinancialYear)    //Create variable

=Sum({<Year={$(vMaxFinancialYear)}>}Sales)

Hope it will work..

[senpradip007]

Create a Calendar for your application as Apr is the starting month and make the year - 1 for Jan, Feb and Mar.

Eg.

Normal Calendar      Transform_Calendar

Jan 2014                         Jan 2013

Feb 2014                         Feb 2013

Mar 2014                         Mar 2013

Apr 2014                         Apr 2014

.

.

Dec 2014                         Dec 2014

Jan 2015                         Jan 2014

Feb 2015                         Feb 2014

Mar 2015                         Mar 2014