Question
Reporting on Upcoming Expiries
My data has a dimension called ExpiryDate.
I’ve created Date Ranges like “Upcoming 3 months”, “Upcoming 12 months”.
I’d like to create a report showing the number of Customers whose expiry date will be in each of those date ranges. I’ve tried using a simple freeform table with ExpiryDate as the dimension and People metric filtered by Date Range, with unexpected results.
In our local systems, we can query our source data accordingly. Any ideas how to approach this with a CJA project?
| Date Range | People |
|---|---|
| Customers with ExpiryDate in Upcoming 3 Months | 10,000 |
| Customers with ExpiryDate in Upcoming 12 Months | 25,000 |