Set analysis Date Range

[tyagishaila]

Dear Community members,

I have these two fields

Created Date	Close Date
1-Oct-16	1-Oct-16
2-Oct-16	2-Oct-16
3-Oct-16
4-Oct-16
5-Oct-16	7-Oct-16
6-Oct-16
7-Oct-16	7-Oct-16
8-Oct-16

And expected result is

	Total	Open	Close
1-Oct-16	1	0	1
2-Oct-16	2	0	2
3-Oct-16	3	1	2
4-Oct-16	4	2	2
5-Oct-16	5	3	2
6-Oct-16	6	4	2
7-Oct-16	7	3	4
8-Oct-16	8	4	4

means for every date , date range start with 1-Oct-16.

Total:     suppose we check for 6-Oct-16 than total created date must be the total of 1st to 6th.

Open

[sunny_talwar]

Sounds good.... let try to make this possible

[tyagishaila]

Good Luck.

I know you will do it.

Ameen.

[sunny_talwar]

So, I spent a lot of time thinking about this and I am still trying to figure out what we need to display. For instance, lets take a look at this

Row 1 -24-Sept-16

1-3 days will show order which were created between 22-Sept-16 and 24-Sept-16 are still open?

Row 2 - 1-Oct-16

1-3 days will show order which were created between 29-Sept-16 and 1-Oct-16 are still open?

Row 3 - 8-Oct-16

1-3 days will show order which were created between 6-Oct-16 and 8-Oct-16 are still open?

I know you explained month. So 1-3 day from the last day of the month, right?

and finally daily would be the same as Weekly. So each day would show the order created within last three days and are still open?

[Anil_Babu_Samineni]

Sunny, I Appreciate Your Harmful Help to  tyagishaila

As i Figure out, This is the Second Thread which is long conversation. Thanks for helping to Employees. i've learned new things here

1) Re: Display message per selection

[tyagishaila]

Yes you are right. exactly this is my requirement.

And really really very very thanks Sunny to spent a lot of time on this.

Thanks

Shaila

[tyagishaila]

Yes Anil you are right.

[sunny_talwar]

Did the open expression ever work for you? Or did you use the approach of using column labels

Total-Closed

[tyagishaila]

No Open expression did not work. I used Total -Closed for open cases

[sunny_talwar]

I think we will have to make the Open expression work for this bucketing to be done. I will keep digging