user06363 Member

Comments

  • Thank you for responding! I've found a solution, For last 4 weeks: CASE WHEN YEARWEEK(`SentDate`,1) >= YEARWEEK(CURDATE(),1)-4 AND YEARWEEK(`SentDate`,1) < YEARWEEK(CURDATE(),1) THEN `METRICNAME` END For last 8 weeks: ((CASE WHEN YEARWEEK(`SentDate`,1) >= YEARWEEK(CURDATE(),1)-8 AND YEARWEEK(`SentDate`,1) <…
    in Last 4 weeks accumulated beast mode Comment by user06363 October 2018
Default Avatar