Yes on the WAU, MAU. The DAU yes but if I were to add a swapper:
CASE [Active Users]
WHEN 'DAU' THEN [DAU]
WHEN 'WAU' THEN [WAU]
WHEN 'MAU' THEN [MAU]
DAU is the only one that will not return the DAU by date. If I use the Previous Day calc then I get cannot mix aggregate and non aggregate error message.
Thoughts? We need to switch between all 3.
Well, I made some changes here. For the Daily, you will see the previous date; for Weekly, you will see the week-end date or last date till which you have data for the week; and for Monthly, you will see the month-end date or last date till which you have data for the month.
Hope this helps.
DAU.twbx 57.1 KB
This does not work if you remove the header. On my dashboard, I have KPI's at the top. When I switch from DAU/WAU/MAU the number should change. It works for WAU & MAU but not DAU. If I change to Avg(DAU) it works fine, however, what I would like is to report is the previous days DAU. If it won't work it is okay, would be nice to have
The previous day should also match the (LAST UPDATED DATE) not sure if this helps.