Can I get running totals in Report Builder?

[manasdatta]

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? 

[TanmayMathur]

Hi, 

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!

Tanmay

[manasdatta]

Hey Tanmay, 

Thanks for the reply. My question was actually around how to display a running total for my data. Any thoughts? 

M

[TanmayMathur]

Hi M,

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!

Tanmay

[manasdatta]

Hey Tanmay, 

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. 

Manas

[spectaprod · Accepted solution]

M,

You can create a custom metric to handle this. Documentation is here.

Mine looks like the attached image, and worked exactly as I expected

[manasdatta]

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.