1 Reply Latest reply on Dec 30, 2016 12:00 PM by Norbert Maijoor

    Compare one item to prior month of another item

    David Joo

      Hello everyone.  3-days into tableau and looking for some help.  I think I'm generally getting the hang of it, but not sure how to do this. 

       

      I have total user_id that are tagged renewal and I have total user_id. 

       

      I want to create a function (not sure if this is the right word) where I can graph the renewal rate:  total user_id_renewal / total user_id (from prior month). 

       

      In excel, I would do something like:  countifs(user_id,"renewal",date,"month") / countifs(user_id,"all",date,"month-1")