5 Replies Latest reply on Sep 14, 2017 10:38 AM by Angela Blackburn

# Calculation for DAU, WAU, and MAU  (Daily, Weekly and Monthly active users)

I am trying to create 3 simple calculations in tableau based on the attached.

DAU (Daily Active Users)  always be today - 1 (Yesterdays date)

Avg DAU (This is easy)

WAU (Weekly active users) based on the week # (See file)

MAU (Monthly Active Users) based on total active users per month.

I cannot wrap my head around the best way to do this and any help would be great.

Thanks!

• ###### 1. Re: Calculation for DAU, WAU, and MAU  (Daily, Weekly and Monthly active users)

Is this what you are looking for?

The workbook is attached. Hope this helps.

• ###### 2. Re: Calculation for DAU, WAU, and MAU  (Daily, Weekly and Monthly active users)

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]

END

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.

• ###### 3. Re: Calculation for DAU, WAU, and MAU  (Daily, Weekly and Monthly active users)

Angela,

I am not sure I understand correctly or not, but how about this?

Thanks,

Shin

<< Ambassador Spotlight Here ! >>

• ###### 4. Re: Calculation for DAU, WAU, and MAU  (Daily, Weekly and Monthly active users)

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.

• ###### 5. Re: Calculation for DAU, WAU, and MAU  (Daily, Weekly and Monthly active users)

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.