Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
I found out issue:
in expression
IF(Num(MYear)>" insert number of month", sum(Var)
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
Hi,
cau u attach a sample file.because its only easy to solve ur requirments
Iyyappan
Hi guys,
Please find attched the file. I need to show data started from Sep 2011.
Thanks,
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,
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
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
I found out issue:
in expression
IF(Num(MYear)>" insert number of month", sum(Var)