Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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?
Hi Janson,
Yes,I want to limit the displayed data in chart.
Best,
Siva
So if today is a Monday you want to show Today and last Friday, correct? And if today is a Saturday? Sunday?
Try the attached Siva. You can adjust the variable vDateRange for your own purposes.
Hope thsi helps,
Jason
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.
Hello There,
Could anyone hlep on this? I
Best,
Siva
Hi,
It's very urgent. can anyone help on this?. can we create variable for this?
Best,
Siva.
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.
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.