[Home] [Help]
View: JTF_PF_APP_SUMMARY_VL
View Text
SELECT MASTER.DAY DAY
, CNT_PAGES_JTF
, CNT_PAGES_OAF
, CNT_PAGES_FORM
, NVL(CNT_FLOWS
, 0) CNT_FLOWS
, CNT_USERS
, CNT_APPS
, CNT_RESPS
, CNT_SESSIONS
, CNT_LANGS
FROM (SELECT DAY
, SUM(DECODE(TECH_STACK
, 'JTF'
, 1
, 0)) CNT_PAGES_JTF
, SUM(DECODE(TECH_STACK
, 'OAF'
, 1
, 0)) CNT_PAGES_OAF
, SUM(DECODE(TECH_STACK
, 'FORM'
, 1
, 0)) CNT_PAGES_FORM
, COUNT(UNIQUE(FLOWID)) UCNT_FLOWS
, COUNT(UNIQUE(USERID)) CNT_USERS
, COUNT(UNIQUE(APPID)) CNT_APPS
, COUNT(UNIQUE(RESPID)) CNT_RESPS
, COUNT(UNIQUE(SESSIONID)) CNT_SESSIONS
, COUNT(UNIQUE(LANGID)) CNT_LANGS
FROM JTF_PF_ALL_ACTIVITY_VL GROUP BY DAY) MASTER
, (SELECT DAY
, SUM(UCNT_FLOWS) CNT_FLOWS
FROM JTF_PF_SESSION_SUMMARY_VL GROUP BY DAY) SES
WHERE MASTER.DAY = SES.DAY(+)
Columns
Name |
DAY |
CNT_PAGES_JTF |
CNT_PAGES_OAF |
CNT_PAGES_FORM |
CNT_FLOWS |
CNT_USERS |
CNT_APPS |
CNT_RESPS |
CNT_SESSIONS |
CNT_LANGS |