http://forums.visokio.com/discussions/tagged/currrent_vs_previous/feed.rss Mon, 30 Oct 17 18:13:21 -0400 Tagged with currrent_vs_previous - Visokio Forums en-CA http://forums.visokio.com/discussion/1772/formulae-time-period-comparisons-wow-or-moms Wed, 19 Sep 2012 12:49:17 -0400 kgurus 1772@/discussions
I have two requirements and both are pretty much linked or part of the same solution:

1. I need to show a table view of metrics and their respective values corresponding to current and previous week. Also, I want to calculate the % different (WoW, MoM etc..) based on the user selections. How do I calculate previous week and show it in the data field?

2. If the user selects only quarter and does not select month or week then the current week and month should be taken as maximum of week and month in that particular quarter. Also, based on this, previous week should be calculated in the background and result should appear.

I have attached a file to explain the desired result. Any help would be greatly appreciated!

Thank you!]]>