3 Replies Latest reply on Jun 27, 2016 7:18 AM by swaroop.gantela

    Plotting DAU/MAU

    Mark Jennings

      Hi All,

       

      I'm very new to Tableau, so please bare with me if this is a simple question.

       

      I have a data set, which contains a list of shopper IDs and the corresponding dates which they have shopped at a particular store. What I am trying to do is calculate from the single date field the distinct daily shopper count divided by the distinct monthly active shopper count - this will allow me to track by day the activity of shoppers (DAU/MAU). I can easily figure out how to plot DAU or MAU on their own, but can't figure out how to show one divided by the other.

       

      Any help would be appriciated. I've searched the forums for an answer but haven't had much luck with the articles I've come across!

       

      Thanks