Total count by Start and End dates

[shree909]

Hi Folks ,

I have a scenario, where i have a data set with start, End, Status and ID.

Start date acts a  Filter with year, Month, Quarter.

when i make any selections on the filters i want to capture the monthend and  and look for that end date between the start and end date from the duplicate table  and show the count on the chart.

for that i created a duplicate table so that i can get all the count,

Example 1:

when 2016 is selected, i want to take the max monthend start date and use that  date to check the duplicate table , and see if the dates is between start and end dates and get the count

Example 2:

when 2016 and 2017 are selected, i want to selected the max month end date of 2016  i.e 12/31/2016 and check between  the duplicate table and get the count,similarly i want to selected the 2017 12/31/2016 and check the dates between the duplicate table and get the count. both these counts should be shown as a line chart . since these charts are not associated i am seeing only the toal counton 2 years

Please find the sample.

Thanks

[sunny_talwar]

Where do you have to take the count Sree? In the bar chart or text box object? What is the expected output in the above 2 scenarios?

[shree909]

i want to show those numbers  as a line chart on the combo chart.i am attaching the file

[aarkay29]

Rangesum(Above(Count({<Status={'NEW'}>}   ID),0,rowno()))   as Line Expresion

[shree909]

Thanks for the response,

but when ever i select any month ,i need to see the monthend value falls between the start and enddate  of the duplicate table. when i use the above formula and make selections it should get the count from the duplicate table.

[shree909]

Any Help on the above scenario?