Problem For reporting purposes we need to know how many users have signed up, but grouped into useful date range intervals (bins). We also need to know the total number of users in the same date bins. Solution The following query works by creating a common table expression (CTE) where the user.cre…

We’ve got some similar ones in this topic if you’d like to test them out and see how they compare: [immagine] Weekly/Monthly/Yearly Signups Data & reporting memo These queries give a breakdown of how many new user accounts have been created within the timefram…

[immagine] JammyDodger: We’ve got some similar ones in this topic if you’d like to test them out and see how they compare Oh nice! Thanks. I thought I’d searched, clearly not well enough or insufficient secret-sauce. That would have saved me some time … sigh

Nuove registrazioni utenti per mese con totale progressivo

Comunità Dati e reportistica

JammyDodger 18 Gennaio 2024, 1:30pm 2

Abbiamo alcuni argomenti simili in questo topic se desideri provarli e vedere come si confrontano:

Argomento		Risposte	Visualizzazioni
Weekly/Monthly/Yearly Signups Data & reporting sql-query	6	657	Gennaio 21, 2024
Get member count overall by month using Data Explorer Data & reporting sql-query	5	654	Febbraio 10, 2021
New users who visited this month? Data & reporting	3	989	Aprile 20, 2021
Calculate total participation moments by month using Data Explorer Data & reporting sql-query	12	1380	Febbraio 25, 2021
Users who posted the most X months ago & how many users in total have posted within that time period Data & reporting sql-query	0	151	Luglio 8, 2019

Nuove registrazioni utenti per mese con totale progressivo

Argomenti correlati