Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello i have this graph and i uset vSetPeriod Range :
I would like Now to display for 2016 and 2015 just the value to this date (value to April 2015 and value April 2016) :
VsetYearlyRange : [Calendar date]=,[Year of date] = ,[Month of date]=, [Year of date] = {"> $(=max([Year of date]) - $1) <= $(=[Year of date])"},[%Date ID] = { "<= $(=max([%Date ID]))"}
vSetMonthlyRange : [Calendar date]=,[Month of date]=, [Year of date]=, [%Year month SEQ] = {"> $(= max([%Year month SEQ]) - $1) <= $(=[%Year month SEQ])"}
Regards
Hello Zied,
At primary level of understanding, you can change the upper bound for [Year of date] & [%Date ID] to get the desired results. BTW, Could you please share the application with sample data?
Regards!
Rahul
Zied,
How your data is organized? Do you have any data points beyond the Today()?
Some data sample would be helpful to build the desired Measure for your chart...
Regards,
Vlad