BI- Extract Hour:Min from date and get Avg
696389Aug 5 2009 — edited Sep 10 2009Hi there,
am working on BI answer and trying to get the average of the working hours of the departments. The Working Hrs column is Date format in the Database. And I managed with Forum help to Extract the Hours from this column and do the average through the BMM in the RPD on the Fact table as following:
EXTRACT( HOUR FROM "Ain_Access"."Fact_Access"."Working Hours")
Now on the BI Answer results I have 8 instead of 08:57.
But what I need is to Extract the Hour and the minuets and get their AVG.
Appreciate your help,