Hi, I'm building a LeadGen and Nurturing dashboard (screenshot attached) to track marketing prospects for school enrollment. I currently have a parameter setup to allow users to change the view to last 30 Days, 60 Days, and 90 Days. In addition to the counts by category, I would like to display growth rate by the time frame selected in the parameter compared to the prior 30 Days, 60 Days, or 90 Days. It appears that a simple growth rate calculated field is not returning results.
This is what I tried: (ZN(COUNTD([Contact ID])) - LOOKUP(ZN(COUNTD([Contact ID])), -1))
Does anyone know how to combine a growth rate calculation with a date range parameter?
Thanks for your time,
Matt
If you create a calculated field for the "if % change" part, you can drag the table calc into the calculated field.
It'll be less messy code wise if you created another calculated field but that isn't necessary.
