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
BedrockMission!

Learn More

View all

Sign in to view all badges

Comparing this week so far with last week(to this point in the week)

Avatar

Avatar
Validate 1
Level 1
nicholass661486
Level 1

Like

1 like

Total Posts

1 post

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 1
nicholass661486
Level 1

Like

1 like

Total Posts

1 post

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
nicholass661486
Level 1

10-07-2018

I'm looking to create a work space that compares KPI for the current week vs last week at the same point using rolling dates so it can be sent out (scheduled). I want to be able to compare count data for this week so far  with last week up to this point  (like you would see on the real time reports e.g. +5.25% vs last week) but when I pull in last week it has the full count for the week. Is this possible? Can anyone help please?

Thanks,

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Boost 5
Level 4
nikitaf2673776
Level 4

Likes

37 likes

Total Posts

70 posts

Correct Reply

32 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile

Avatar
Boost 5
Level 4
nikitaf2673776
Level 4

Likes

37 likes

Total Posts

70 posts

Correct Reply

32 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile
nikitaf2673776
Level 4

10-07-2018

You can create custom Date Ranges. I recommend these two. They will capture the same whole days this week vs last week. I.e. Sunday through end of yesterday. You don't want to include today's data because the same day last week was a complete day, whereas today's data is incomplete.

Last Week:

  • Start: Start of current week minus 1 week
  • End: End of current day minus 8 days

This Week:

  • Start: Start of current week
  • End: End of current day minus 1 day

Answers (1)

Answers (1)

Avatar

Avatar
Contributor
MVP
AlexisCazes
MVP

Likes

186 likes

Total Posts

420 posts

Correct Reply

198 solutions
Top badges earned
Contributor
Shape 1
Give Back 10
Give Back 5
Give Back 3
View profile

Avatar
Contributor
MVP
AlexisCazes
MVP

Likes

186 likes

Total Posts

420 posts

Correct Reply

198 solutions
Top badges earned
Contributor
Shape 1
Give Back 10
Give Back 5
Give Back 3
View profile
AlexisCazes
MVP

11-07-2018

See this link as well: Create custom date ranges