Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Rolling Time segment

Avatar

Level 1

01-09-2017

We need a time segment that take current weekday and compare it to average of the same weekday the last 12 weeks.

Eg. One section has xx pageviews this Friday - and to find out if its high or low level, we need the average of the last 12 weeks, on the same day. As we are a news publisher house, we cannot just compair with yesterday or same day last week, as everyday is affected of todays history.

The segment is required to be rolling dates as we wan't to display the numbers in a data visualization app.

1 Comment