Forum Discussion

obothewizard's avatar
obothewizard
Icon for Helper I rankHelper I
3 years ago
Solved

Calculate daily open rate %

Hi there, 

 

I need to get the daily open rates for the below table but since Send Date is only recorded on Nov 24th I'm getting null/infinity return with my calculations for the open volumes recorded 25th/26th/27th

 

My data has an event_type field which was used to create the three calculated fields in my table below. The TOTAL_VOLUME measure was preloaded with the data.

 

Email Sent = COUNTROWS(filter(PRODUCTION_TRACKING_DASHBOARD,PRODUCTION_TRACKING_DASHBOARD[EMAIL_EVENT_TYPE]="Sent"))
 
Email Opens = COUNTROWS(filter(PRODUCTION_TRACKING_DASHBOARD,PRODUCTION_TRACKING_DASHBOARD[EMAIL_EVENT_TYPE]="Open"))
 
Open % = [Email Opens]/[Email Sent]
 

 

 

Any help would be much appreciated! 🙂

 

Thanks

Eve

Need Help
  • obothewizard's avatar
    obothewizard
    3 years ago

    Actually just solved it using a new calculation for emails sent with ALL and FILTER

2 Replies