AnsweredAssumed Answered

Retention Rate Report

Question asked by bruns on Apr 30, 2018
Latest reply on May 1, 2018 by erolst

I have a database for a shelter that gives food boxes away.  Each participant can receive one box per month.  They would like a report that would tell them if the people are repeat customers.  I currently have a portal setup on each customers page to record when they receive a box.  My problem is,  I cannot even begin to think of where to start.  In theroy, I would like to run a report that would tell if a person received a box each month for what ever two dates I have setup ( I have two global date fields) and tell me if they are at 100% retention rate for that period or what rate they are at.  Is this even possible?  Any ideas is appreciated.

Outcomes