cancel
Showing results for 
Search instead for 
Did you mean: 
smalldog
Level 12

miss hour report

Jump to solution

Hi All, i create reports on web reporter but when view report, hour column just show hour not plus minutes (see attach, just see 6.00 - 7:00, not show 6:15 or 6:30...).  How to show hour + minutes? Thanks!

0 Kudos
1 Solution

Accepted Solutions
sroering
Level 13

Re: miss hour report

Jump to solution

On the edit query dialog, there is a drop down on the first screen that has "Summary Data" and "Detail Data".  Just select the detail data, then you will need to rebuild the query by adding columns and adjusting the sort order on the column properties tab, etc.

0 Kudos
3 Replies
sroering
Level 13

Re: miss hour report

Jump to solution

Correct, hour is hour.  If you need the exact time, then you need to modify the query for the report to use detail data. The screenshot you provided appears you are using summary data which is aggregated into hour buckets by site.

0 Kudos
smalldog
Level 12

Re: miss hour report

Jump to solution

Thanks Sroering, could you show me how to modify the query to display detail data?

0 Kudos
sroering
Level 13

Re: miss hour report

Jump to solution

On the edit query dialog, there is a drop down on the first screen that has "Summary Data" and "Detail Data".  Just select the detail data, then you will need to rebuild the query by adding columns and adjusting the sort order on the column properties tab, etc.

0 Kudos