Forum Stats

  • 3,782,951 Users
  • 2,254,713 Discussions
  • 7,880,227 Comments

Discussions

average of first logon_time for multiple days

table description:

NAME Null? Type
-------------------
USER_ID VARCHAR2(30)
LOGON_DAY DATE
LOGON_TIME VARCHAR2(10)

Logon_day contains full logon date + time

logon_time contains logon time as varchar2


i'm able to get the first logon_time for any specific day but i need to get the average of the first logon times for a number of days

i'm able to create a query that gives me the result but i need to do it in obiee

anyone got an idea of how to do this?
Tagged:
This discussion has been closed.