Hi @DavidRoss91  Sorry that I may not explain myself well. Actually, I wonder the current profiles only have ECID, when are they created, then I need to know the amount of the creation date within Oct. Like by Oct1, we can use your sql to get the amount and profiles, but what if the profiles login a...

Thanks for your reply.but below date_key is the total amount of single profile created by the day,  not the amount only on the day...qsaccel.profile_agg.adwh_fact_profile_by_namespace_trendlines.date_key BETWEEN '2024-10-01' AND '2024-10-31' I would like the query to see the counts of profiles that ...

HiWe'd like to know the current profiles(have ECID but without OCMDID), how many of them created the profile within October?What's the query to search