Calendar "Compare Dates" Option Should be More Flexible

Avatar

Avatar

sunshynegirl84

Avatar

sunshynegirl84

sunshynegirl84

19-07-2010

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 (2 New)
2 Comments

Avatar

Avatar

hjalmar6

Avatar

hjalmar6

hjalmar6

19-07-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.

Avatar

Avatar

jmborange

Avatar

jmborange

jmborange

18-03-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.