I have two dates referal_date and disposed_date. I need to count how many cases were pending (not disposed) at the end of each month that were referred in the previous month(s). so if I had a data set like: referral_date disposed_date 1/1/2022 null 2/5/2022 1/10/2…

Determine Pending at End of Month Based on Two Dates

Naveed February 13, 2023, 4:34am 2

Hi,

May this help you.

regards,
Naveed Ali

Topic		Replies	Views
How to get previous month count Q&A analysis , filters , calculations , how-to	1	834	January 31, 2023
How to compare the date between current and previous record Q&A date , calculations	4	4764	April 18, 2022
Month to Date vs Last Year's Month To Date Comparison Q&A calculations , how-to	4	2915	May 26, 2023
Retention and Churn - Checking previous month's status as of current calendar date Q&A calculations	3	2134	May 18, 2023
Count of Trailing Twelve Months - On Filter Q&A calculations	1	1175	January 6, 2022