Expand my Community achievements bar.

Calendar "Compare Dates" Option Should be More Flexible

Avatar

Level 2

7/19/10

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 Comments

Avatar

Level 4

7/19/10

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.

Avatar

Level 1

3/18/13

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.