How to display hours as days on an hour report?

Forum|Forum|9 years ago
April 6, 2016
5 respostas
1137 Visualizações

I have an Hours matrix report. I would like to display the values as Days instead of hours. E.g. If the item is 8 hours, this would show as 1 day. 12 hours would show as 1.5 days, etc. According to the advanced reporting manual, it looks like it may be possible. I have tried changing the displayformat to be "minutesAsDaysString" but it treats the hours as if they are minutes when converting them to days, so the result is wrong. I can‚Äö√Ñ√¥t see how to get it to convert Hours to Days. I also can‚Äö√Ñ√¥t (obviously) create a custom field on Hours objects so I can‚Äö√Ñ√¥t convert hours to Days that way. Any help would be greatly appreciated! Regards, David

Este tópico foi fechado para respostas.

imgrund

Adobe Employee

Hi David, Have you tried changing the valuefield=hours to valueexpression=DIV({hours},8)?

D

DavidCo3Autor

Level 10

Thanks Anthony. That does the trick in terms of showing the line-level records as day values. I've then played around with a few options to try to get the aggregators to also show the total in days but I'm not having much luck yet. If I use the same concept to make aggregator.valueexpression=DIV({hours},8) the report won't display properly. Reverting back a step, what I currently have is the following. If you have any further suggestions it would be appreciated. aggregator.displayformat=doubleAsDouble aggregator.function=SUM aggregator.namekey=hours aggregator.valuefield=hours aggregator.valueformat=doubleAsDouble displayname= linkedname=direct namekey=hours querysort=hours textmode=true valueexpression=DIV({hours},8) valueformat=doubleAsDouble

imgrund

Adobe Employee

So I was playing around... It seems if you have a custom field/aggregator, it does not work show the value in the summary tab, matrix reporting, or in a chart. I went to some other reports that are different object tabs and getting the same thing. So weird. I would have thought if it can display in the details tab, it could display in a matrix or chart. If you have any remote consulting hours left, you might want to schedule some time with Jason Webre. He is great on unique reporting needs. :)

D

DavidCo3Autor

Level 10

OK - thanks for looking into it further, Anthony. I've booked in some time with our local consulting team in Australia. Will see how we go! Cheers

C

CatherineHa

Hello! I have the same question. Were you able to aggregate the data into days ? Thank you! Catherine Simonson