Time series with irregular dates seems to be summing up certain values

Hi! 

I'm charting open rate over time for emails. 

All of my open rates are below 0.75 (i.e. 75%), but when I chart them, I get spikes above 1 and even 2. 

Screenshot 2024-10-10 at 10.05.05.png

I think it's because sometimes, more than 1 email went out in a given period (like maybe a week) and instead of creating individual points along the chart for each of these, it's summing the available values for each given period (probably week).  

I hope that makes sense. 

Either way, can someone confirm? And if so, help me figure this out? 

Many thanks. 

0 0 57
0 REPLIES 0
Top Labels in this Space
Top Solution Authors