Week start selection

[its_anandrjs]

Hi All,

I have urgent requirement that if i select the weekstart value in weekstart list box

it should display like when selection 8/8/2011

it should display this

8/7/2011

8/6/2011

8/5/2011

8/4/2011

8/3/2011

8/2/2011

8/1/2011

and sum the values on that days.

Regards

Anand

[#2]

I may not undertsand the question - do you want to display each day as listed, or a sum for the listed date? Either way  it should work as long as all your rows contain one field for the real date, and one field for the weekstart date.

What is shown then it depends on what fileds you choose to display...

[sushil353]

Hi Anand,

Your problem is not understandable..please explain a bit more..

[its_anandrjs]

Hi,

Thanks for this on for this days

8/7/2011

8/6/2011

8/5/2011

8/4/2011

8/3/2011

8/2/2011

8/1/2011

How many customers are disconnect i need to find out but only on above days from 8/7/2011 to 8/1/2011 but selection is 8/8/2011 (Weekstart), If you need more information tell me and let me know.

Regards

Anand

[its_anandrjs]

Hi Kjer / All,

Scenario is this when i select the weekstart like 8/8/2011 so below dates are what

like this

8/7/2011

8/6/2011

8/5/2011

8/4/2011

8/3/2011

8/2/2011

8/1/2011

on this some customers are disconnect so i need to find out this like example:-

8/7/2011  22

8/6/2011  15

8/5/2011  10

8/4/2011   8

8/3/2011   5

8/2/2011   4

8/1/2011   41

But this shuold work for all weekstarts like 8/8/2011, 8/15/2011, 8/22/2011, 8/29/2011 any year it should work.

Regards

Anand

[#6]

Is it numbers of customer disconnected per day in teh choisen week you are looking for?

Then I think the following should work:

If your customer row contain the following fields

customer_id

Date_for_disconnect

weekstart(date_for_disconnect) as Week_start

A listbox on select Week_start  let you choose the week

And a chart/diagram displaying

Date_for_disconnect

count(customer_id)

[sushil353]

Yup.. i get it

make two variables wStart and wEnd assign wStart= weekstart(DATE) and wEnd= weekstart(Date)-7

then in your chart sum({<DATE={">=$(wEnd)<$(wStart)"}>} Customer)

I hope you will get the idea..

HTH

[its_anandrjs]

Hi,

Thanks yes right you understand it but iwant to display that ids on that perticular dates like

8/7/2011  22

8/6/2011  15

8/5/2011  10

8/4/2011   8

8/3/2011   5

8/2/2011   4

8/1/2011   41

On 8/7/2011 there is 22 person disconnect but i want to display its IDS like in any Straight table like

8/7/2011 ID01

8/7/2011 ID02

8/7/2011 ID03

.....

.....

....

like ways all

Thanks

Anand

[#9]

Then the display should be without the count function

And a chart/diagram displaying

Date_for_disconnect

customer_id

[its_anandrjs]

Hi,

But how only for this dates of selection from 8/8/2011

8/7/2011  22

8/6/2011  15

8/5/2011  10

8/4/2011   8

8/3/2011   5

8/2/2011   4

8/1/2011   41

for below six dates only and it should work for all week start.

Let me know

Regards

Anand