Dear support team,
Tracked time is being shown in hours throughout all default reporting widgets. When monitoring a whole project, having the time visible in days would give better information.
Division in an odata query like:
$apply=aggregate(BillablePeriodLength div 8 with sum as PeriodLength)
only provides half of the solution, as the result is still treated as hours and minutes: 28 hours are being shown as 3:30 (days).
When changing format to "Number", division as part of the query no longer delivers the right result.
Example: PeriodLength of 17:00 hours is being shown as 61200 when using number format (17x3600).
When applying a division by 3600 as part of the query, the widget shows 16.
I did try the MathExpression formatting as well, but with no success either.
What would be the best way, to show aggregated tracked time in days on reporting widgets?
Thanks, Dieter
-
Hello Dieter,
There is no out of the box feature for this, and in this instance only some workarounds that you have tried might help, but we haven't checked which workaround would work best. Also, this sounds more like a feature request, so we have moved it to the Feature Requests section, so that our Product Owner can check it.
Best regards,
Vanja -
Hello Dieter,
just to follow up on Vanja's message above, as he said this is something we'd need to build as it's not provided by Time Tracker out of the box. We'll keep an eye on this thread and if it gets enough upvotes we'll raise it higher with our Development Team.
Regards,
Andrea
Product Owner - www.7pace.com
Please sign in to leave a comment.
Comments
3 comments