4 Replies Latest reply: Jul 14, 2017 3:41 AM by beck bakytbek RSS

    Same Month Prior Year's data

    Reiko Hayami

      Hi I have the below 2 expressions working with a help from this forum.  They show 2016 full year total # and 2017 YTD #.  Now the management wants this done for current month this year and the same month prior year, so it would be Jul-17 and Jun-17.

       

      2016:

      100*count({<[Overall Experience]={'Exceeds'},[Completed Year]={2016}>} [Would Recommend])/Count({<[Completed

      2017: 

      100*count({<[Overall Experience]={'Exceeds'},[Completed Year]={2017}>} [Would Recommend])/Count({<[Completed Year]={2017}>} [Overall Experience])

       

      What would be the expression for Jul-16 and Jul-17?  Thank you.