Good morning, people!
I need to make a calculation that looked super simple, but I'm in trouble because of the date filter.
I'm showing the amount of leads per day, in the month of August. I need to include a second graph of the cumulative amount of leads from
a year ago, showing the same days of August.
Example: in the day bar on August 1, the calculation should consider the cumulative August 1, 2015 until August 1, 2016, the second bar (August 2) the cumulative August 2, 2015 until August 2, 2016 August and so on.
However, because of the filter, my date is limited to only August 2016 and the calculation does not work.
Could help me, please?
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 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!
