Skip to main content
sunshynegirl84
Level 2
July 19, 2010
Declined

Calendar "Compare Dates" Option Should be More Flexible

  • July 19, 2010
  • 2 replies
  • 1745 views

When looking at a single date range, using 7/11/2010 - 7/17/2010, I don't like that when I then select to "Compare Dates" and select the week prior (7/4/2010 - 7/10/2010), the "Change" column does the calculation based on OLD minus NEW (i.e. week ending 7/10/2010 minus week ending 7/17/2010 - see attachment).  The only way to get around this is to move the order of the date ranges to pull the old dates first; however, this doesn't seem like a great solution, since the report then shows the older data next to the prop/evar values.

It would be great if the "Change" column would calculate based on the left column of data minus the right column of data.

2 replies

jmborange
New Participant
March 19, 2013

I fully support this. This has been an issue for years now and provokes question marks all around the organisation. I cannot believe so few people have a problem with this.

hjalmar6
Level 3
July 20, 2010

I always missing the option compare last week with the week before or last month with the month before. Or compare last month with the same month of last year.