How to show today and yesterday data only in designer part?

[siva_boggarapu]

Hi Everyone,

I have a chart, in that chart i have a 10 fields. here my question I want to show chart data today and yesterday data only. If the day is  falls on Sat and sat. On  Monday I want to see since friday to Monday data. can any one help on this.

Can any one help on this?

Best,

siva.

[jagannalla]

Hello,

Change the variable expression as below if dates are sequence, but your dates are not in sequnce. what you want to do know?

=IF(WeekDay(Now())*1=5 or WeekDay(Now())*1=6,

     Chr(39) & Date(Now())& Chr(39) & ',' & Chr(39) & Date(Num(Now())-1)& Chr(39)& ',' & Chr(39) & Date(Num(Now())+1)& Chr(39)& if(WeekDay(Now())*1=5,',' & Chr(39) & Date(Num(Now())+2)& Chr(39),',' & Chr(39) & Date(Num(Now())-2)& Chr(39)) ,

    IF(WeekDay(Now())*1=0,

       Chr(39) & Date(Now())& Chr(39) & ',' & Chr(39) & Date(Num(Now())-3)& Chr(39),

              Chr(39) & Date(Now())& Chr(39) & ',' & Chr(39) & Date(Num(Now())-1)& Chr(39) ) ) 

- Can explain what you want exactly according to your data. I mean whether it should compare with present dates or according to your dates.

- If dates are in differen format please change the format in variable itself

[jagan]

Hi Siva,

Hope attached file helps you in solving your problem.  In this I used to variables, vEndDate holds current date and vStartDate holds previous working day(Monday-Friday).  Based on this dates I limit the calculation in set analysis expression. 

Regards,

Jagan.