Hi All, How can I get the total usage in a slice? I want to run reports using total usage.
The slices may not provide you a true total, if you're talking about things like the total usage in terms of estimates + actuals for an assignment/task/project, due to seeing a limited range of time that the slices cover.
Instead you would want to take the prassignment fields practsum and prestsum, add them together, and divide by 3600 (converting seconds to hours) to create a total usage value.
Thanks Nick, I was hoping to use this in BO an use the slice request for total usage, we only need to see 12 months worth of data. I may have to create a variable.
You can get task assignment etc/actuals in BO I think in daily/weekly/monthly/quarterly segments. Depending on how you're trying to aggregate you may need to make a variable on the report but shouldn't require editing the Universe I dont think.
Retrieving data ...