Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I Have a bar graph with the dimension "Year" and some filters in the Dashboard with the all years available.
I need to limit the years to appears in the graph to three, and If I select only one year in the same way I need show always three year.
Any suggestions to do this?
Thanks in advance.
What are the three years you need to constant? Which year you are selecting and what are the years you want to do keep. How many years you have in document?
Now in the document I have 4 years, {2014, 2015, 2016 and 2017}. But this dimension will be increased.
I what be always three years in the graph, even when I select a year, i.e. Year = 2014. The result need to be {2014, 2015 and 2016} for Year = 2016 the result {2015, 2016, 2017} or something similar.
May be use set analysis to always show three years?
As i understand, you may need Set analysis
sum({<Date = {">=$(=AddYears(Year, -3)) <=$(=max(Year))"} >} Sales)
Some corrections
Three years from selection. If 2014 is selected, this will show 2012, 2013, & 2014 (even if 2016 is the max year available)
Sum({<Year= {">=$(=Max(Year)-3)<=$(=Max(Year))"} >} Sales)
or
Will always show 2014, 2015, 2016 (again assuming max year in the application is 2016)
Sum({<Year= {">=$(=Max({1}Year)-3)<=$(=Max({1}Year))"} >} Sales)
stalwar1, with what kind of expression?
Because in the "Graph Properties " -> "Dimension Limits " I what to "show only" [3 Values] but isn't correct.
I already have some expressions.
Yes, I am assuming he don't have Forecast year
Then how are you using this in your set analysis?
sum({<Date = {">=$(=AddYears(Year, -3)) <=$(=max(Year))"} >} Sales)
Hahaha, Typo error. I am assuming he has Forecast Year data. But i even doubt about difference
Sum({<Year= {">=$(=Max({1}Year)-3)<=$(=Max({1}Year))"} >} Sales)
OR
Sum({1<Year= {">=$(=Max(Year)-3)<=$(=Max(Year))"} >} Sales)