Forum Documentation Showcase Pricing Learn more

How to display sign-ups in a calendar month?


#1

Hi,

I am building an admin page and one of the stats that I would like to display is the ‘number of sign-ups in a particular period eg; last calendar month, week, etc’…

what is the best way?


#2

I use Search for users:filtered:count
the filtered part is Creation date>currentdate/time +(days)-30
wont give you the exact month but the last 30 days


#3

thanks @denverdave11 that’s worked…

it would be nice to also be able to work out the stats based on calendar months, so to be able to trend the data.


#4

hey! could you solve this? I have a similar question, but I have payments in the database, and i would love to split the payments due amount per month and Im becoming crazy about how to do this


#5

Bumping this - I also need the solution. :slight_smile:


#6

Hi @maryfox20 :slight_smile: This can be set up using a graph and the :groupedby operator. Here is an example for displaying signups over the past month (grouped by day):