This post was marked as "assumed answered", is that correct? If so, let us know what the solution was! Otherwise, let us know and we can take a closer look. A packaged workbook will always make it easier for us to answer questions.
It seems that the same discussion was opened twice. My mistake.
The correct answer was gave by David Li:
Resposta corretapor David Li em 26/08/2016 08:47
Hi Fabio, is this what you're looking for? The top graph shows the current month's daily leads, and the bottom one is a rolling 365-day sum of the leads. (But it won't be accurate on leap years).
To do this, I removed the date filter so all data would show. The top bar is just the sum of leads, and the bottom bar is just a quick table calculation for a moving calculation with sum of leads. Then, I used the LAST() = 0 trick I mentioned before to keep only this particular month visible.
If this is the correct solution, please mark it as such! Thanks!
Thanks for the followup!