Hey team,
i'm hoping someone can help me here; i created a Parameter allow me to create a lead source funnel based on a filtered report. The filtered report gives me a total number of 861 leads (represented by the top left summary number).
The parameter created basically states "IF this THEN category"; which gives me 3 categories within the 861 total of Owned, Rejected, and converted. So far everything is working very well. However I would like to represent the 861 total from the summary number as the TOP most block on my funnel visual... can i do this by adding something to my funnel parameter?
My funnel parameter, see visual attached for result:
(CASE
WHEN `Converted` = 'true' THEN '3. Rep Converted'
WHEN `Status` = 'Rejected' AND
`Lead Status Reason` = 'Bad Data' OR
`Lead Status Reason` = 'Consumer' OR
`Lead Status Reason` = 'Customer Service Request' THEN '2. Rep Hard Reject'
WHEN `Owner ID` <> 'Home Use' THEN '1. Rep Owned'
WHEN `Owner ID` <> 'Dead Data' THEN '1. Rep Owned'
ELSE 'Other'
END)
Summary 861 total to top of funnel help?