Compare dates in dashboard with both start dates being fixed | Community
Skip to main content
S
stephaniej71500
March 18, 2016
Solved

Compare dates in dashboard with both start dates being fixed

  • March 18, 2016
  • 1 reply
  • 1261 views

I have a dashboard that I would like to do a TY/LY comparison with, and I would like the start date for both ranges to be fixed (3/6/15-rolling date and 3/4/16-rolling date). However, I seem to only get the option to choose fixed or rolling for my first set of dates (LY in this case, see screenshot attached). My other set of dates (TY in this case), just seems to constantly roll. When I originally set up the dashboard, we were only a week into the time period (7 days). So now, my dates show 3/6/15-3/19/15 (this is correct) compared to 3/11/16-3/17/16 (last 7 days, incorrect because I wanted the first date to hold at 3/4/16). Is there a way to remedy this without have to resort to using report builder instead?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by DavidGo5

Hi - have you looked at Analysis Workspace for this? There you can create a number of date ranges and save them for example

Start date: Start of this week minus 53 weeks

End date is: End of this week minus 53 weeks

They have some prebuilt ones such as 'last' week and 'two weeks ago' too, to get you started.

1 reply

D
DavidGo5Accepted solution
Level 2
May 16, 2016

Hi - have you looked at Analysis Workspace for this? There you can create a number of date ranges and save them for example

Start date: Start of this week minus 53 weeks

End date is: End of this week minus 53 weeks

They have some prebuilt ones such as 'last' week and 'two weeks ago' too, to get you started.

Terms & ConditionsAccessibility statement

Loading footer...