Hello, I have a graph in analytics where I have a goal field for how many sales I want to make each day. The problem is when there are no sales made on a day it is left blank and the running total field that is adding the goal values together each day skips the blank day resulting in the final monthly totally being less than it should. Is there a way to get around this?

thank you!