So a couple of things,
I made it so there is an entry point even if there is no gross for every line. The graph looks a lot nicer now in the initial gross.
With the database dump I was given grosses for some movies were missing on some days while the majority of Grosses are okay, for example Ex Machina the gross appears and reappears throughout the month. This is probably the symptom of a larger problem, but my way of solving the symptom is if the gross is less than the previous day's gross, use the previous day's gross. Hopefully this is sufficient, doing it per movie (instead of per-line) seemed to be a lot more complicated.
So a couple of things, I made it so there is an entry point even if there is no gross for every line. The graph looks a lot nicer now in the initial gross.
With the database dump I was given grosses for some movies were missing on some days while the majority of Grosses are okay, for example Ex Machina the gross appears and reappears throughout the month. This is probably the symptom of a larger problem, but my way of solving the symptom is if the gross is less than the previous day's gross, use the previous day's gross. Hopefully this is sufficient, doing it per movie (instead of per-line) seemed to be a lot more complicated.