
1. Re: Indicator Calculation  Accumulated
diego.medrano Sep 22, 2016 4:32 PM (in response to Fabio Garcia)Hey Fabio,
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.
Thanks,
Diego

2. Re: Indicator Calculation  Accumulated
Fabio Garcia Sep 29, 2016 8:28 AM (in response to diego.medrano)Hi, Diego
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 365day 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!

3. Re: Indicator Calculation  Accumulated
diego.medrano Sep 29, 2016 9:33 AM (in response to Fabio Garcia)Thanks for the followup!