How to make our design flexible?

[Anonymous]

Hi

i am having dashboard in which i have comparison of sales based on year and season. I want to compare 2015 year sales with 2017

how to implement the same ?

the date represented above chart as 2016(is a text box in which under text option it is written as (=prev_year)  has following coding in the script

Let currentdate =DATE(Today(1)-1,'YYYYMMDD');
Let Curr_Year = Year(Today());
Let Prev_Year = (Year(Today())-1);

[MK9885]

Alternate States?

[hallquist_nate]

You could use Set Analysis to do this, I think.  You use a Set expression like Year = {"$(=Max(Year))"} In your formula.  It might look something like....

Sum({$<Year = {"$(=Max(Year))"} >} Sales)       //This is for Current year sales, or "max selected year".

Sum({$<Year = {"$(=Max(Year)-2)"} >} Sales)       //This is for the Max selected year -2, or 2015. 

You would use these as 2 different expressions in your chart and you would be able to get your two different years.

Hope this helps.

Nate

[Anonymous]

yes

inhereted

[Anonymous]

I have assigned following values to my variables in the script itself

Let currentdate =DATE(Today(1)-1,'YYYYMMDD');
Let Curr_Year = Year(Today());
Let Prev_Year = (Year(Today())-1);

then i have used this variables curr_year and prev_year in my chart expressions

=num(

sum(if(Sold_Date <= MakeDate(Prev_Year,month(To),day(To)) and Sold_Date >= MakeDate(Prev_Year,month(From),day(From)),  [inv value]))/Sales_INR_Unit,

'#,##0.0')

now i want to assign the variable curr_year so that it can show comparison between any season les than  2017 ie curr_year

so what changes i have to do for the same in my variable declaration?