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.

[Jason_Michaelides]

Do you want to limit the data loaded by the script (ie only today and yesterday's data is available at all) or do you want to limit the displayed data in a chart?

[siva_boggarapu]

Hi Janson,

Yes,I want to limit the displayed data in chart.

Best,

Siva

[Jason_Michaelides]

So if today is a Monday you want to show Today and last Friday, correct?  And if today is a Saturday? Sunday?

[Jason_Michaelides]

Try the attached Siva.  You can adjust the variable vDateRange for your own purposes.

Hope thsi helps,

Jason

[siva_boggarapu]

Hi Janson,

I want to be filter data like below

•    For Monday it should pull data  issued between Friday and Monday (Till the Time report refreshes)

•    For Tuesday it should pull data issued between Monday and Tuesday (Till the Time report refreshes)

•    For Wednesday it should pull data  issued between Tuesday and Wednesday (Till the Time report refreshes)

•    For Thursday it should pull data  issued between Wednesday and Thursday (Till the Time report refreshes)

•    For Friday it should pull data  issued between Thursday and Friday (Till the Time report refreshes)

Best,

Siva.

[siva_boggarapu]

Hello There,

Could anyone hlep on this? I

Best,

Siva

[siva_boggarapu]

Hi,

It's very urgent. can anyone help on this?. can we create variable for this?

Best,

Siva.

[jagannalla]

Hi siva,

I tried your problem, but i want to know that when the file is opened on sat & sunday what you need to display.

Apart from that the attached file works well.

[siva_boggarapu]

Hi Jagan,

Thanks for posting answer for this.  Can please have a look below screen shot. The report will be reloaded eveyday. But in chart I want to show only since yesterday to today data. If the day falls on sat and sun. I want to show the chart since friday to monday.

I can appriciate you, if i get correct answer.

Best,

Siva.