Hello Experts, this is my scenario:
I'm creating a KPI dashboard for e-mail campaigns started in SAP Marketing Cloud. The live connection is set up and working. I want to create a chart that shows how e.g. the delivery rate of e-mails develops over time.
The chart should display a percentage x that shows this:
x = [ Delivered Emails / Sent E-Mails (timeframe selected in filter) / Delivered Emails / Sent E-Mails (complete timeframe)]
My problem is that I can't figure out how to calculate the ratio for all the data I have back to day 1 and than use that rate with another rate calculated for the selected timeframe in the dashboard.
Thank you for taking the time to read this far.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.