Need to calculate daily/monthly ratio. How to combine two date ranges in one card?
I need to calculate a daily users / monthly users ratio, but I am stumped as to how to build the Beast Mode to indicate the following logic: "COUNT(DISTINCT `user id`) for every day and divide by COUNT(DISTINCT `user id`) for the whole month" This will be calculating this ratio over time.
I don't know if this can be built as a beast mode or if it shoud be done in the ETL, but mostly I am confused as to how to indicate both counts with different date ranges, one daily and one monthly in the same card.
Any help is much appreciated! Thanks.