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…

Hi, May this help you. [image] How to get previous month count Question & Answer Hi, How to get previous month total count. im using periodOverPeriodLastValue but it does not return total of previous month. periodOverPeriodLastValue(sum(sessioncount), {start_date},MONT…

Hi @ugadawg90 I wonder if you could use a calculated field something like IsPending: ifelse(dateDiff(referral_date, now()) >= 1 AND dateDiff(disposed_date, now()) <= 1, 1, 0) Then you would have a 1 or 0 depending on if it was disposed. I’m using now() in the calculation, but if you wanted to run…

Let me check that this week. I appreciated the reply.

I am testing this formula. I had to account for the Dispostion Date being null. ifelse(dateDiff({Referral Date}, now()) >= 1 AND dateDiff({Disposition Date}, now()) <= 1 OR dateDiff({Referral Date}, now())>=1 AND isNull({Disposition Date}), 1, 0) My dataset has some duplicate rows so chose Max fo…

Hey @ugadawg90 Does this problem still exist? Where is the data off from what you have now?

Determine Pending at End of Month Based on Two Dates

Q&A

Naveed February 13, 2023, 4:34am 2

Hi,

May this help you.

regards,
Naveed Ali

Topic		Replies	Views
PeriodOverPeriodDifference Question on Month End Calculation Q&A quick-sight , calculations , pivot-table , Business-Intelligence-Engineer	8	97	July 23, 2025
Sum of current month till date i.e. max of date in data same for Previous months Q&A date , quick-sight , calculations , Business-Intelligence-Engineer	1	140	June 3, 2024
How to get previous month count Q&A analysis , filters , quick-sight , calculations	1	848	January 31, 2023
Exisitng rows as derrived column Q&A date , quick-sight , calculations , Business-Intelligence-Engineer	3	140	February 6, 2024
Calculation to set the previous month's total as current month actual value Q&A analysis , error , quick-sight , visuals , calculations , Business-Intelligence-Engineer	7	604	August 7, 2024

Determine Pending at End of Month Based on Two Dates

Related topics