:memo: These queries give a breakdown of how many new user accounts have been created within the timeframe, excluding staged and non-activated accounts. The totals are broken down by number of signups each week/month/year, a running total for the time period selected, and a total number to date whi…

Hi, apologies for being so obtuse about how this works, but what does one of these examples look like when the dates are filled in?

I’m not sure what you mean? There’s an example of the results underneath each, if that’s what you’re looking for?

Understood. Here’s what I’m trying to ask: Where in the code itself do I put my start and end date, and in what format do I write it?

[画像] Carson: Where in the code itself do I put my start and end date You don’t, as it should add input boxes above the button to run the query (if not, refresh after saving and they’ll show up), then [画像] Carson: and in what format do I write it? I think it’ll just give you a date pic…

Ah, yes. There’s a known issue where the parameter input boxes don’t show up the first time until after a page refresh. It’s not quite swish enough yet to have a date picker (though here’s hoping :slight_smile: :crossed_fingers:), but I think it’s quite forgiving on format. I use the UK date format…

Got it now. Thanks. Needed the page refresh.

週次/月次/年次サインアップ

コミュニティデータとレポート

Firepup650 (Firepup Sixfifty) 2024 年 1 月 21 日午前 12:26 6

コード内にはありません。クエリを実行するボタンの上に、入力ボックスが追加されるはずです（表示されない場合は、保存後に更新してください）。

日付ピッカーが表示されると思います。

トピック		返信	表示
New user signups by month with running total Data & reporting sql-query	2	380	2024 年 1 月 18 日
Dashboard Report - Signups Data & reporting sql-query , dashboard-reports , dashboard-sql	1	641	2024 年 12 月 24 日
Retrospectively pulling number of users each calendar month Data & reporting	9	408	2024 年 11 月 12 日
New users who visited this month? Data & reporting	3	1067	2021 年 4 月 20 日
Calculate total participation moments by month using Data Explorer Data & reporting sql-query	12	1483	2021 年 2 月 25 日

週次/月次/年次サインアップ

関連トピック