Start with specific month

[Anonymous]

Hi guys,

Help me create an expression which show data from specific month( for example from November 2011) in a chart.

When I load my data, I use it to calculate Month of Year.

      MonthName(Monthstart(submitDateTime)) as MYear,

Thanks,

[#2]

Hi vovan4ik,

You can try loading the 'submitDateTime' as island table. Then code a variable

vMYear = MonthName(Monthstart(submitDateTime)) by going to Setting --> Variable overview --> Add

Once you have done that, create your chart with an appropriate dimension.

Add an expression with set analysis as below:

sum( {1<Month ={'$(vMYear)'}>} sales)

where Month is the calendar field with same format as vMYear and sales is the detail field that you wnat the chart to be based off of.

Thanks

[v_iyyappan]

Hi,

     cau u attach a sample file.because its only easy to solve ur requirments

Iyyappan

[Anonymous]

Hi guys,

Please find attched the file. I need to show data started from Sep 2011.

Thanks,

[Anonymous]

Could you help me to create variable, which shows or have months started from Sep 2011 and ...?

In chart or in Load.

Thank you in advanced,

[v_iyyappan]

Hi,

     Use the Where Condition in Load Script'

Table2:

Load

    Date,

    Month(Date) AS Month,

    Value AS Amount

Resident Table1

Where (Month(Date) * 1)  >= 9;

Regards,

Iyyappan

[SunilChauhan]

convert your Myear in 

Month-Year format  ex: Jan-2012

and the use below code

sum({<myear={">=$(=addmonths(max(mYear),-12))<=$(=addmonths(max(mYear),0))"}>} Sales)

hope this helps

[Anonymous · Accepted solution]

I found out issue:

in expression

IF(Num(MYear)>" insert number of month", sum(Var)