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

Month to date last year

Avatar

Avatar
Validate 1
Level 1
chrism86658944
Level 1

Likes

2 likes

Total Posts

2 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 1
chrism86658944
Level 1

Likes

2 likes

Total Posts

2 posts

Correct Reply

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

27-03-2018

Morning Everyone! I see this in a few other threads but haven't spotted the answer yet. I'm looking to set up some workspace dashboards to show "month to date" compared to the same time period from last year.

I can do this by manually amending the time segments each time but would much rather have this automated. Can anybody help?
Chris

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 1
Level 5
nickh86417692
Level 5

Likes

68 likes

Total Posts

66 posts

Correct Reply

26 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 25
View profile

Avatar
Validate 1
Level 5
nickh86417692
Level 5

Likes

68 likes

Total Posts

66 posts

Correct Reply

26 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 25
View profile
nickh86417692
Level 5

27-03-2018

Go up to "Components", then "Date Ranges". Create one date range for Current MTD and another for Last Year MTD.

For Current MTD, set the rolling dates to: START: start of current month END: end of current day
For Last Year MTD, set the rolling dates to: START: start of current month minus 12 months END: end of current day minus 365 days

And now you have two dynamic date ranges that you can pull into any project for year over year MTD.

Answers (1)

Answers (1)

Avatar

Avatar
Validate 1
Level 1
chrism86658944
Level 1

Likes

2 likes

Total Posts

2 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 1
chrism86658944
Level 1

Likes

2 likes

Total Posts

2 posts

Correct Reply

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

29-03-2018

This is great! Many thanks for this. Just gave it a go and works a treat. I've amended a tadge as was finding I was getting a full day for last year and only a part day for this year so was slightly skewing the results.

To amend I applied the following:

For Current MTD, set the rolling dates to: START: start of current month END: end of current day minus 1 day

For Last Year MTD, set the rolling dates to: START: start of current month minus 12 months END: end of current day minus 366 days