DAU and MAU as measures for a "not" aggregated table

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

0 0 289
0 REPLIES 0
Top Labels in this Space
Top Solution Authors