2 Replies Latest reply on Mar 15, 2016 11:23 AM by Callie Kovack

    Calculate Difference Month to Month

    Callie Kovack

      Hi,

       

      I am designing a workbook with a dataset that includes contacts in our database that have clicked on at least one of our emails. It shows every email click completed by a contact and the date of each click.

       

      I have a trend line that shows for each month, the number of contacts that completed at least one email click. I would also like to show the "drop off" between each month, which I am struggling with. I want to show how many people that clicked on an email in January did not click on an email in February and how many that clicked on an email in February did not click on an email in March, etc. I would like to show this on the same trend line chart that shows the number of contacts that clicked on an email per month.

       

      Any suggestions/insight on this would be great -- a sample workbook is attached. Thank you!