Comments
-
Exactly. As of 2/8/18 there is $X in revenue as one bar in the stack. As of 2/8/17 there was $X revenue as one bar in the stack. Grouped by city and summing the number. The date field is 'close date' and the $ field is just 'revenue'. I stumbled upon this as a PY solution: SUM(CASE WHEN `Close Date` <=…
-
Thanks for the quick response! As of now I am getting a syntax error on the CY BeastMode with '%Y-%m-01' highlighted in red.
