Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
I do have problems with a line graph and some fixed values I need actually --> the graph is looking like this right now (date selection on February 2016):
Where I am struggling with is that I want to have all month of a year listed in the dimension axis --> so January till December (Independent which month is selected). The second thing is, that I like to have all values of the previous year listed --> so in this example that the line in the datatable below of 2015 is filled out till december - also the line of the previous year should show the complete previous year.
Thank you a lot for your help!
Regards,
Barbara
What is the expression you are using right now? Seems like a YTD expression.
No - the values are monthly sums (order values).
The Dimension is Month:
The expressions are actual year values and previous year values per month:
Expression AY:
Expression PY:
we are using two variables - one for OrderValues and one for Setting the acutal year:
vOrderValues: num(sum({<$(vClearCalendar),$2>} OrderValue$(vCurrency).VBAP)/$1,'#.##0')
vAYYearSet: Date ={">=$(=date(yearstart(Date)))<=$(=Date)"}
vPYYearSet: Date ={">=$(=date(addmonths(yearstart(Date),-12)))<=$(=date(addmonths(Date,-12)))"}
vClearCalendar: ='[' & Concat({1<$Table={'CALENDAR'}>} $Field, ']=,[') & ']='
Try these changes
vAYYearSet: Date ={">=$(=Date(Yearstart(Max(Date))))<=$(=Date(Max(Date)))"}
vPYYearSet: Date ={">=$(=Date(AddMonths(YearStart(Max(Date)),-12)))<=$(=Date(AddMonths(Max(Date),-12)))"}
I tried it with your changes - but nothing changed...
how is it possible to make Settings at the Dimension axis skala??