Setting Goals for each Quarter in Bar Chart
I am trying to set goals for each individual quarter. My data is currently represented as a stacked bar chart and would like to make the goals a line. My series is calculating the count of each type of lead for each fiscal quarter. I am having trouble with my beastmode calculation setting the goal value of leads for each fiscal quarter. This is how my calculation is currently and I am getting a syntax error:
WHEN `Created Date` = '2018-Q1' THEN Count(`Type`='518')
WHEN `Created Date` = '2018-Q2' THEN COUNT(`Type`= '1224')
WHEN `Created Date` = '2018-Q3' THEN COUNT (`Type`='1373')
WHEN `Created Date` = '2018-Q4' THEN COUNT (`Type`= '1778')
I would like the goals for each quarter to be placed on a line on top of the bar graph.
Anyone have a solution?