6 Replies Latest reply on Aug 2, 2018 5:12 AM by Zhouyi Zhang

    Last week's CVR Calculation

    yuji minami

      Hi there. I'm trying to figure out how to get "Last week's CVR" visualised in text but so far no luck... hopefully someone could shed some light on.


      I used this to get last week's sales and it works but if I replace [Revenue] with [CVR], which is "sum(transactions)/sum(sessions)"  then it fails as it mixes "aggregate and non-aggregate"...


      >Last week's sales

      LOOKUP(WINDOW_SUM(SUM(IIF([Last Week?],[Revenue],NULL))),0)


      >Last week's CVR

      LOOKUP(WINDOW_AVG(AVG(IIF([Last Week?],[CVR],NULL))),0)


      Being still a learner, I'd appreciate anyone's guidance on this.