have your tried just using the date (either recast the date time to date or just take the date portion) and countd( the user id) and count(test)
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
I have, unfortunately it does not take into account the creation date of the user so divides by the total number of users in all cases
I would be expecting
date: count(app_open_id)/count(user_id that were created on that date)