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?
Please sign in to leave a comment.