I'm trying to put together a little report with some marketing channels - trials, sales etc. by week over a 3 month period.
I've got the data, but what I'd like to do is present the weekly data as a running total, and then compare that with different patterns.
Is there any way to get a running total in Report Builder?
You can create a custom metric to handle this. Documentation is here.
Mine looks like the attached image, and worked exactly as I expected
Ah! Ascending_sort! That's probably it. Going to take a look now,I'm pretty confident this is going to work! Thanks for your help.
Really appreciate your support :-). Attached is a little Excel sheet that will explain the kind of output I am trying to generate. I hope that this helps.
It would be great if you could show a sample structure of the report that you are willing to create. That would help me in understanding your requirements better. Thanks!
Thanks for the reply. My question was actually around how to display a running total for my data. Any thoughts?
If I understand your query correctly you want to have a report showing the data for the last 3 months with weekly numbers in a row and the last 3 months would be a rolling date.
In the Report Builder you can select 'Rolling Dates' and then specify 'Rolling weekly' and then under 'Apply granularity' also select week. I think this would give you the required result.
Let me know if that solves your question. Thanks!