Nested Concatenations in Beast Mode
Whenever we use nested Concatenations with Case Statements, every Concatenations gives a break line. How to avoid that ? CONCAT( 'Last Week SEO had ', ROUND(SUM(CASE WHEN WEEK(DATE_SUB(`Date`,1)) = WEEK(DATE_SUB(CURRENT_DATE(),7)) and YEAR(`Date`) = YEAR(CURDATE()) and `Tracking Code Program` = 'SEO' and `API Name` =…