Skip to content
[Home] [Help]
View: JTF_PF_PAGE_SUMMARY_VL
View Text
SELECT DAY DAY
, PAGENAME PAGENAME
, TECH_STACK TECH_STACK
, COUNT(PAGENAME) CNT_PAGES
, COUNT(SESSIONID) CNT_SES
, COUNT(UNIQUE(SESSIONID)) UCNT_SES
, COUNT(UNIQUE(USERID)) UCNT_USERS
, COUNT(UNIQUE(APPID)) UCNT_APPS
, COUNT(UNIQUE(RESPID)) UCNT_RESPS
, COUNT(UNIQUE(LANGID)) UCNT_LANGS
, SUM(EXECT) SUM_EXECT
, SUM(THINKT) SUM_THINKT
, COUNT(THINKT) CNT_THINKT
, MIN(STARTT) STARTT
, MAX(STARTT+EXECT) ENDT
, SUM(DECODE(STATUSCODE
, -100
, 1
, 0)) CNT_FAIL
, SUM(DECODE(STATUSCODE
, -200
, 1
, 0)) CNT_FORWARD
FROM JTF_PF_ALL_ACTIVITY_VL GROUP BY DAY
, PAGENAME
, TECH_STACK
Columns
| Name |
| DAY |
| PAGENAME |
| TECH_STACK |
| CNT_PAGES |
| CNT_SES |
| UCNT_SES |
| UCNT_USERS |
| UCNT_APPS |
| UCNT_RESPS |
| UCNT_LANGS |
| SUM_EXECT |
| SUM_THINKT |
| CNT_THINKT |
| STARTT |
| ENDT |
| CNT_FAIL |
| CNT_FORWARD |
APPS.JTF_PF_PAGE_SUMMARY_VL