Hi, I am new to looker so please bear with me. I am trying to make the DAU and MAU for my company. I tired this block which aggregates the date (group by) and it works perfectly. This generates the DAU and MAU as dimensions that correspond to the date column.
Now I want these for a table that is not aggregated by date. I want to keep the original time stamps for the transactions. I tried to define them as measures but I am not getting the results I should. This is the measure I defined to get the MAU
measure: mau_try {
type: count_distinct
sql: ${TABLE}."UserID";;
filters: [event_date: "30 days"]
}
Please tell me where I am going wrong.
Thanks