How to get all users that signed up in the last 30 days? I suppose I need some builtin SQL function to generate this date format and then do -30 days. I’ve tried a few examples from the Interwebz, such as this , but I get a syntax error. WITH query_period AS ( SELECT date_trunc('month', CURRENT_DATE…

Got it. SELECT username FROM users WHERE created_at >= CURRENT_TIMESTAMP - INTERVAL '30 days' AND staged = false

You might have a look in Topics tagged data-explorer or Discourse Data Explorer or What cool data explorer queries have you come up with? for some examples.

Query SQL per gli ultimi utenti creati negli ultimi 30 giorni

Supporto

pfaffman (Jay Pfaffman) 15 Agosto 2022, 2:56pm 2

Potresti dare un’occhiata a Topics tagged data-explorer o Discourse Data Explorer o Quali fantastiche query di Data Explorer ti sono venute in mente? per alcuni esempi.

Argomento		Risposte	Visualizzazioni
Active users in the last 30 days Data & reporting sql-query	3	385	Settembre 5, 2016
SQL query for users who have posted on a date (or date range) Data & reporting sql-query	8	1500	Luglio 11, 2021
Users Last Seen Since (Since N Days Ago) Data & reporting sql-query	0	170	Maggio 1, 2016
Show data for last X days Data & reporting sql-query	3	495	Gennaio 24, 2022
User_stats with a proper time stamp Data & reporting sql-query	8	1086	Agosto 15, 2023

Query SQL per gli ultimi utenti creati negli ultimi 30 giorni

Argomenti correlati