I'm trying to get rollups to play better with weekly reports.
I've got a bunch of metapoints that run on times to calculate various things. These are all working fine.
However, I don't know how to get these to reliably output as "business week" style things in the report.
By "Business Week" I mean Last 7 days from Sunday night (So, say, Monday -> Sunday as a "business week"). We're outputting data that is compared to something else, and they use Business Week as Data. Mango's "week" is apparently DAY OF YEAR Modulus 7, which is fine, but provides difficulty for "business week" output.
Here's my report setup:
TIME PERIOD: Previous 7 days
Rollup Type: SUM of 7 DAYS
Data calculated hourly
With that, when I run the report, I'm expecting the Time Stamp to be the START of the period or the END of the period. For example, when we do a "Previous 1 month" the timestamp stored in the excel spreadsheet is the 1st of the previous month.
However, with the time period / rollups I described above ,the timestamp stored in the excel spreadsheet tends to be like, the Friday in the middle of the period? I'm confused by this, and so are the customers.
So: Guess my questions are:
(1) How does Mango chose the timestamp when using Previous 7 Days time period and 7 day sum rollup, and
(2) Is there something I'm missing about how to get Mango to understand the concept of "business week" (Monday->Sunday) rather than modulus week (Day of Year % 7)?
This throws off our calculations a bit, since if you use a SUM on a month in the Watchlist viewer, you get fine data, and it all jives. But if you do SUM over a week, it looks odd, and insists on plotting values on Fridays rather than any other day. This presents a problem for us, since the data we're comparing to is done on Business Week (Monday -> Sunday) type basis.