Query for registrations in the last 30 days

[Sadashii]

Hey there,

Before I ask for my request I must say, great job with this repository! Has helped me setup my whole redash.

Could you help me out with a query similar to the one like "Monthly Signup with date range." except it show's the registrations for the last 30 days

Thanks in advance

[rririanto]

Hi @Sadashii glad to know that! could you give me an example output?

[Sadashii]

So say today the date is 8th August, the query would show me daily registrations for the last 30 (or a number which can be set ofc) days. So like, the first output would be of 30 days before, ie 9th July, 10th, 11th... 31st July, 1st August, 2nd, 3rd... To today (today could have just started as well so like the registration since today started)

I'm hoping this is a better clarification

Regards, Tanishq Sangwan

~ Rome wasn't built in a day, everyone and everything starts at zero

On Mon, 8 Aug, 2022, 2:41 pm Rahmat Ramadhan, @.***> wrote:

Hi @Sadashii https://github.com/Sadashii glad to know that! could you give me an example output?

— Reply to this email directly, view it on GitHub https://github.com/rririanto/redash-query-cheatsheets-mongodb/issues/1#issuecomment-1207867272, or unsubscribe https://github.com/notifications/unsubscribe-auth/AOL7GCWEUPIPBUPEJJ7FBDDVYDFMTANCNFSM5533CIRA . You are receiving this because you were mentioned.Message ID: @.*** com>

[Sadashii]

Anything maybe?