Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Cumulative count between 2 dates column.

Hi All,    I have a property data with columns start date and end date. I want to find the cumulative count of the property live based on the start date and end date based on the property status.  ...
Date
date interval
datesbetween
Pragati11's avatar
Pragati11
Super User
6 years ago

Hi Anonymous ,

 

This doesn't help in answering your query. You want to calculate SUM of COUNTS of which column?

Can you please screesnhot some sample data with few rows?

 

Thanks,

Pragati

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Pragati11, 

     

    Updated the query with some 10 sample data and expected solution. I hope this gives an idea, please let me know if it needs further more clarity. 

     

    Thanks,

    Kanthi.