Deployments
UAT_PCR_Deployment
Reports
Report Name: Maternity Leave without Pay
Overview

  • Queries: 15

    Layouts: 1

  • Model: /PCR/PCR Deployment/PCR Packages/packagePCR-RCP/ name: model
Queries
  • Queries 15
    Expressions:
  • Model: /PCR/PCR Deployment/PCR Packages/packagePCR-RCP/ name: model
  • Query
    All Mat LWOP
    Data Items
    31
    Case Number
    [Presentation].[Case].[ID]
    Contact Info
    [Presentation].[Case].[CONTACT_INFO]
    Age
    [Presentation].[Case].[CMT_AGE]
    Assigned To
    [Presentation].[Case].[ASSIGNEE_CURR]
    label
    Assigned Agent
    Team Name
    [Presentation].[VW_STG_CURRENT_TEAM].[Team_Name]
    Date Open
    [Presentation].[Case].[DATE_OPEN]
    Date Effective From
    [Presentation].[Case].[DATE_EFFECTIVE_FROM]
    BF Date
    [Presentation].[Case].[DATE_BF]
    Classification
    [Presentation].[Case].[CLASSIFICATION]
    State Name
    [Presentation].[State].[NAME]
    State
    case
    when [All Mat LWOP].[State Name] in ('Reassigned', 'Open', 'Invalid') then ('Unassigned')
    when [All Mat LWOP].[State Name] = 'Ready_To_Verify' then 'Ready To Verify'
    else [All Mat LWOP].[State Name]
    end
    State Sort
    case
    [State]
    when 'Unassigned' then 1
    when 'Assigned' then 2
    when 'Pending' then 3
    when 'Ready To Verify' then 4
    else 99
    end
    Business Unit
    [Presentation].[VW_STG_DEPARTMENT].[CODE]
    PRI
    [Presentation].[Case].[PRI]
    Work Type Name
    [Presentation].[Work Type].[NAME]
    Sub Type Name
    [Presentation].[Sub Type].[NAME]
    Created By
    [Presentation].[Case].[CREATED_BY]
    EX / Non EX
    [Presentation].[Case].[SUBJECT]
    POD
    [Presentation].[VW_STG_DEPARTMENT].[POD]
    Awaiting Calc
    [Presentation].[Case].[AWAITING_CALC]
    Awaiting Confirm
    [Presentation].[Case].[AWAITING_CONFIRM]
    Awaiting Off Cycle
    [Presentation].[Case].[AWAITING_OFF_CYCLE]
    Awaiting pay sheet creation
    [Presentation].[Case].[AWAITING_PAY_SHEET_CREAT]
    Waiting on Comp Sector
    [Presentation].[Case].[WAITING_ON_COMP_SECTOR]
    Waiting on documents
    [Presentation].[Case].[WAITING_ON_DOCUMENTS]
    Waiting on HR
    [Presentation].[Case].[WAITING_ON_HR]
    Waiting on prior case completion
    [Presentation].[Case].[WAITING_ON_PRIOR_CASE_COM]
    Age Group
    case
    when [Age] between 0 and 4 then '0 - 4 '
    when [Age] between 5 and 9 then '5 - 9 '
    when [Age] between 10 and 15 then '10 - 15 '
    when [Age] between 16 and 20 then '16 - 20 '
    when [Age] > 20 then '+21 '
    else 'error'
    end
    + [days label - dynamic language ]
    Age Group Sort
    case
    when [Age] between 0 and 4 then 1
    when [Age] between 5 and 9 then 2
    when [Age] between 10 and 15 then 3
    when [Age] between 16 and 20 then 4
    when [Age] > 20 then 5
    else 6
    end
    days label - dynamic language
    if ( #sq($runLocale)# = 'fr' ) then ('jours') else ('days')
    Language
    [Presentation].[VW_STG_EMPLOYEE].[LANG]
    • Detail Filters
      2
    • Required
      [Presentation].[Sub Type].[SUB_TYPE_CODE] in ( 'ST-529', 'ST-938' )
    • Required
      [Presentation].[State].[NAME] in ('Assigned', 'Invalid', 'Open', 'Pending', 'Ready_To_Verify', 'Reassigned', 'Triage_Follow-Up', 'Verified')
      or
      (
      [Presentation].[State].[NAME] = 'Bring_Forward'
      and cast( _add_hours( [Presentation].[Case].[DATE_BF], -5), date) = current_date
      )
  • Query
    All Mat LWOP - Chart
    Data Items
    5
    Cases
    count([All Mat LWOP].[Case Number])
    Aggregate
    total total
    Rollup
    total total
    State
    [All Mat LWOP].[State]
    State Sort
    [All Mat LWOP].[State Sort]
    Age Group
    [All Mat LWOP].[Age Group]
    Age Group Sort
    [All Mat LWOP].[Age Group Sort]
  • Query
    0 - 20 Mat LWOP
    Data Items
    7
    Age Group
    [All Mat LWOP].[Age Group]
    Age Group Sort
    [All Mat LWOP].[Age Group Sort]
    Case Number
    [All Mat LWOP].[Case Number]
    Aggregate
    count count
    Rollup
    total total
    State
    [All Mat LWOP].[State]
    State Sort
    [All Mat LWOP].[State Sort]
    Summary(State Name)
    aggregate(currentMeasure within detail [State])
    solveOrder
    1
    label
    TOTAL Still Meeting SS
    Summary(Age Group)
    aggregate(currentMeasure within detail [Age Group])
    solveOrder
    1
    label
    Total
    • Detail Filters
      1
    • Required
      [All Mat LWOP].[Age] < 21
  • Query
    Over 20 Mat LWOP
    Data Items
    6
    Age Group
    [All Mat LWOP].[Age Group]
    Age Group Sort
    [All Mat LWOP].[Age Group Sort]
    Case Number
    [All Mat LWOP].[Case Number]
    Aggregate
    count count
    Rollup
    total total
    State
    [All Mat LWOP].[State]
    State Sort
    [All Mat LWOP].[State Sort]
    Summary(State Name)
    aggregate(currentMeasure within detail [State])
    solveOrder
    1
    label
    TOTAL over SS
    • Detail Filters
      1
    • Required
      [All Mat LWOP].[Age] >= 21
  • Query
    All WIP
    Data Items
    39
    Case Number
    [Presentation].[Case].[ID]
    Contact Info
    [Presentation].[Case].[CONTACT_INFO]
    Age
    [Presentation].[Case].[CMT_AGE]
    Assigned To
    [Presentation].[Case].[ASSIGNEE_CURR]
    label
    Assigned Agent
    Team Name
    [Presentation].[VW_STG_CURRENT_TEAM].[Team_Name]
    Date Open
    [Presentation].[Case].[DATE_OPEN]
    Date Effective From
    [Presentation].[Case].[DATE_EFFECTIVE_FROM]
    BF Date
    [Presentation].[Case].[DATE_BF]
    Classification
    [Presentation].[Case].[CLASSIFICATION]
    State Name
    [Presentation].[State].[NAME]
    Business Unit
    [Presentation].[VW_STG_DEPARTMENT].[CODE]
    PRI
    [Presentation].[Case].[PRI]
    Work Type Name
    [Presentation].[Work Type].[NAME]
    Sub Type Code
    [Presentation].[Sub Type].[SUB_TYPE_CODE]
    Sub Type Name
    [Presentation].[Sub Type].[NAME]
    Created By
    [Presentation].[Case].[CREATED_BY]
    EX / Non EX
    [Presentation].[Case].[SUBJECT]
    POD
    [Presentation].[VW_STG_DEPARTMENT].[POD]
    Awaiting Calc
    [Presentation].[Case].[AWAITING_CALC]
    Awaiting Confirm
    [Presentation].[Case].[AWAITING_CONFIRM]
    Awaiting Off Cycle
    [Presentation].[Case].[AWAITING_OFF_CYCLE]
    Awaiting pay sheet creation
    [Presentation].[Case].[AWAITING_PAY_SHEET_CREAT]
    Waiting on Comp Sector
    [Presentation].[Case].[WAITING_ON_COMP_SECTOR]
    Waiting on documents
    [Presentation].[Case].[WAITING_ON_DOCUMENTS]
    Waiting on HR
    [Presentation].[Case].[WAITING_ON_HR]
    Waiting on prior case completion
    [Presentation].[Case].[WAITING_ON_PRIOR_CASE_COM]
    days label - dynamic language
    if ( #sq($runLocale)# = 'fr' ) then ('jours') else ('days')
    Age Group
    case
    when [Age] between 0 and 4 then '0 - 4 '
    when [Age] between 5 and 9 then '5 - 9 '
    when [Age] between 10 and 15 then '10 - 15 '
    when [Age] between 16 and 20 then '16 - 20 '
    when [Age] > 20 then '+21 '
    else 'error'
    end
    +[days label - dynamic language ]
    Age Group Sort
    case
    when [Age] between 0 and 4 then 1
    when [Age] between 5 and 9 then 2
    when [Age] between 10 and 15 then 3
    when [Age] between 16 and 20 then 4
    when [Age] > 20 then 5
    else 6
    end
    All Cases
    count( [Case Number] for report )
    Awaiting Calc - bin
    if ( [Presentation].[Case].[AWAITING_CALC] ='Yes/Oui') then (1) else (0)
    Aggregate
    total total
    Rollup
    total total
    Awaiting Confirm - bin
    if ( [Presentation].[Case].[AWAITING_CONFIRM] ='Yes/Oui') then (1) else (0)
    Aggregate
    total total
    Rollup
    total total
    Awaiting Off Cycle - bin
    if ( [Presentation].[Case].[AWAITING_OFF_CYCLE] ='Yes/Oui') then (1) else (0)
    Aggregate
    total total
    Rollup
    total total
    Awaiting pay sheet creation - bin
    if ( [Presentation].[Case].[AWAITING_PAY_SHEET_CREAT] ='Yes/Oui') then (1) else (0)
    Aggregate
    total total
    Rollup
    total total
    Waiting on Comp Sector - bin
    if ( [Presentation].[Case].[WAITING_ON_COMP_SECTOR] ='Yes/Oui') then (1) else (0)
    Aggregate
    total total
    Rollup
    total total
    Waiting on documents - bin
    if ( [Presentation].[Case].[WAITING_ON_DOCUMENTS] ='Yes/Oui') then (1) else (0)
    Aggregate
    total total
    Rollup
    total total
    Waiting on HR - bin
    if ( [Presentation].[Case].[WAITING_ON_HR] ='Yes/Oui') then (1) else (0)
    Aggregate
    total total
    Rollup
    total total
    Waiting on prior case completion - bin
    if ( [Presentation].[Case].[WAITING_ON_PRIOR_CASE_COM] ='Yes/Oui') then (1) else (0)
    Aggregate
    total total
    Rollup
    total total
    Language
    [Presentation].[VW_STG_EMPLOYEE].[LANG]
    • Detail Filters
      2
    • Required
      [Presentation].[Sub Type].[SUB_TYPE_CODE] in ( 'ST-228', 'ST-529' , 'ST-938')
    • Required
      [Presentation].[State].[NAME] in ('Assigned', 'Pending', 'Ready_To_Verify', 'Verified')
  • Query
    Active WIP - All
    Data Items
    3
    All Cases
    count([Presentation].[Case].[ID])
    Aggregate
    total total
    Rollup
    total total
    Total Age
    [Presentation].[Case].[CMT_AGE]
    Aggregate
    total total
    Rollup
    summarize summarize
    Average Age
    total( [Total Age] ) / total( [All Cases] )
    Aggregate
    calculated calculated
    Rollup
    calculated calculated
    • Detail Filters
      2
    • Required
      [Presentation].[Sub Type].[SUB_TYPE_CODE] in ( 'ST-529', 'ST-938' )
    • Required
      [Presentation].[State].[NAME] in ('Assigned', 'Pending', 'Ready_To_Verify', 'Verified')
  • Query
    Active WIP - Calc
    Data Items
    5
    All Cases
    count([Presentation].[Case].[ID])
    Aggregate
    total total
    Rollup
    total total
    Awaiting Calc - bin
    if ( [Presentation].[Case].[AWAITING_CALC] ='Yes/Oui') then (1) else (0)
    Aggregate
    total total
    Rollup
    total total
    Awaiting Calc %
    total( [Awaiting Calc - bin] ) / total( [All Cases] )
    Aggregate
    calculated calculated
    Rollup
    calculated calculated
    Total Age - Awaiting Calc
    if ([Presentation].[Case].[AWAITING_CALC] ='Yes/Oui' ) then ( [Presentation].[Case].[CMT_AGE]) else ( 0 )
    Aggregate
    total total
    Rollup
    summarize summarize
    Average Age
    total( [Total Age - Awaiting Calc] ) / total( [Awaiting Calc - bin] )
    Aggregate
    calculated calculated
    Rollup
    calculated calculated
    • Detail Filters
      2
    • Required
      [Presentation].[Sub Type].[SUB_TYPE_CODE] in ( 'ST-529', 'ST-938' )
    • Required
      [Presentation].[State].[NAME] in ('Assigned', 'Pending', 'Ready_To_Verify', 'Verified')
  • Query
    Active WIP
    Data Items
    33
    All Cases
    [All WIP].[Case Number]
    Aggregate
    count count
    Rollup
    total total
    Awaiting Calc - bin
    [All WIP].[Awaiting Calc - bin]
    Aggregate
    total total
    Awaiting Calc %
    [Awaiting Calc - bin] / [All Cases]
    Aggregate
    calculated calculated
    Rollup
    calculated calculated
    Total Age - Awaiting Calc
    if ([All WIP].[Awaiting Calc - bin] = 1 ) then ( [All WIP].[Age] ) else ( 0 )
    Aggregate
    total total
    Rollup
    summarize summarize
    Average Age - Awaiting Calc
    [Total Age - Awaiting Calc] / [Awaiting Calc - bin]
    Aggregate
    calculated calculated
    Rollup
    calculated calculated
    Awaiting Confirm - bin
    [All WIP].[Awaiting Confirm - bin]
    Aggregate
    total total
    Awaiting Confirm %
    [Awaiting Confirm - bin] / [All Cases]
    Aggregate
    calculated calculated
    Rollup
    calculated calculated
    Total Age - Awaiting Confirm
    if ([All WIP].[Awaiting Confirm - bin] = 1 ) then ( [All WIP].[Age] ) else ( 0 )
    Aggregate
    total total
    Rollup
    total total
    Average Age - Awaiting Confirm
    [Total Age - Awaiting Confirm] / [Awaiting Confirm - bin]
    Aggregate
    calculated calculated
    Rollup
    calculated calculated
    Awaiting Off Cycle - bin
    [All WIP].[Awaiting Off Cycle - bin]
    Aggregate
    total total
    Awaiting Off Cycle %
    [Awaiting Off Cycle - bin] / [All Cases]
    Aggregate
    calculated calculated
    Rollup
    calculated calculated
    Total Age - Awaiting Off Cycle
    if ([All WIP].[Awaiting Off Cycle - bin] = 1 ) then ( [All WIP].[Age] ) else ( 0 )
    Aggregate
    total total
    Rollup
    total total
    Average Age - Awaiting Off Cycle
    [Total Age - Awaiting Off Cycle] / [Awaiting Off Cycle - bin]
    Aggregate
    calculated calculated
    Rollup
    calculated calculated
    Awaiting pay sheet creation - bin
    [All WIP].[Awaiting pay sheet creation - bin]
    Aggregate
    total total
    Awaiting Pay Sheet Creation %
    [Awaiting pay sheet creation - bin] / [All Cases]
    Aggregate
    calculated calculated
    Rollup
    calculated calculated
    Total Age - Awaiting Pay Sheet Creation
    if ([All WIP].[Awaiting pay sheet creation - bin] = 1 ) then ( [All WIP].[Age] ) else ( 0 )
    Aggregate
    total total
    Rollup
    total total
    Average Age - Awaiting Pay Sheet Creation
    [Total Age - Awaiting Pay Sheet Creation] / [Awaiting pay sheet creation - bin]
    Aggregate
    calculated calculated
    Rollup
    calculated calculated
    Waiting on Comp Sector - bin
    [All WIP].[Waiting on Comp Sector - bin]
    Aggregate
    total total
    Waiting on Comp Sector %
    [Waiting on Comp Sector - bin] / [All Cases]
    Aggregate
    calculated calculated
    Rollup
    calculated calculated
    Total Age - Waiting on Comp Sector
    if ([All WIP].[Waiting on Comp Sector - bin] = 1 ) then ( [All WIP].[Age] ) else ( 0 )
    Aggregate
    total total
    Rollup
    total total
    Average Age - Waiting on Comp Sector
    [Total Age - Waiting on Comp Sector] / [Waiting on Comp Sector - bin]
    Aggregate
    calculated calculated
    Rollup
    calculated calculated
    Waiting on documents - bin
    [All WIP].[Waiting on documents - bin]
    Aggregate
    total total
    Waiting on Documents %
    [Waiting on documents - bin] / [All Cases]
    Aggregate
    calculated calculated
    Rollup
    calculated calculated
    Total Age - Waiting on Documents
    if ([All WIP].[Waiting on documents - bin] = 1 ) then ( [All WIP].[Age] ) else ( 0 )
    Aggregate
    total total
    Rollup
    total total
    Average Age - Waiting on Documents
    [Total Age - Waiting on Documents] / [Waiting on documents - bin]
    Aggregate
    calculated calculated
    Rollup
    calculated calculated
    Waiting on HR - bin
    [All WIP].[Waiting on HR - bin]
    Aggregate
    total total
    Waiting on HR %
    [Waiting on HR - bin] / [All Cases]
    Aggregate
    calculated calculated
    Rollup
    calculated calculated
    Total Age - Waiting on HR
    if ([All WIP].[Waiting on HR - bin] = 1 ) then ( [All WIP].[Age] ) else ( 0 )
    Aggregate
    total total
    Rollup
    total total
    Average Age - Waiting on HR
    [Total Age - Waiting on HR] / [Waiting on HR - bin]
    Aggregate
    calculated calculated
    Rollup
    calculated calculated
    Waiting on prior case completion - bin
    [All WIP].[Waiting on prior case completion - bin]
    Aggregate
    total total
    Waiting on Prior Case Completion %
    [Waiting on prior case completion - bin] / [All Cases]
    Aggregate
    calculated calculated
    Rollup
    calculated calculated
    Total Age - Waiting on Prior Case Completion
    if ([All WIP].[Waiting on prior case completion - bin] = 1 ) then ( [All WIP].[Age] ) else ( 0 )
    Aggregate
    total total
    Rollup
    total total
    Average Age - Waiting on Prior Case Completion
    [Total Age - Waiting on Prior Case Completion] / [Waiting on prior case completion - bin]
    Aggregate
    calculated calculated
    Rollup
    calculated calculated
    • Detail Filters
      1
    • Required
      [All WIP].[Sub Type Code] = 'ST-529'
  • Query
    Active WIP - Confirm
    Data Items
    5
    All Cases
    count( [Presentation].[Case].[ID] )
    Aggregate
    total total
    Rollup
    total total
    Awaiting Confirm - bin
    if ( [Presentation].[Case].[AWAITING_CONFIRM] ='Yes/Oui') then (1) else (0)
    Aggregate
    total total
    Rollup
    total total
    Awaiting Confirm %
    total( [Awaiting Confirm - bin] ) / total( [All Cases] )
    Aggregate
    calculated calculated
    Rollup
    calculated calculated
    Total Age - Awaiting Confirm
    if ([Awaiting Confirm - bin] = 1 ) then ( [Presentation].[Case].[CMT_AGE] ) else ( 0 )
    Aggregate
    total total
    Rollup
    total total
    Average Age
    [Total Age - Awaiting Confirm] / [Awaiting Confirm - bin]
    Aggregate
    calculated calculated
    Rollup
    calculated calculated
    • Detail Filters
      2
    • Required
      [Presentation].[Sub Type].[SUB_TYPE_CODE] in ( 'ST-529', 'ST-938' )
    • Required
      [Presentation].[State].[NAME] in ('Assigned', 'Pending', 'Ready_To_Verify', 'Verified')
  • Query
    Active WIP - Off Cycle
    Data Items
    5
    All Cases
    count( [Presentation].[Case].[ID] )
    Aggregate
    total total
    Rollup
    total total
    Awaiting Off Cycle - bin
    if ( [Presentation].[Case].[AWAITING_OFF_CYCLE] ='Yes/Oui') then (1) else (0)
    Aggregate
    total total
    Rollup
    total total
    Awaiting Off Cycle %
    total( [Awaiting Off Cycle - bin] ) / total ( [All Cases] )
    Aggregate
    calculated calculated
    Rollup
    calculated calculated
    Total Age - Awaiting Off Cycle
    if ([Awaiting Off Cycle - bin] = 1 ) then ( [Presentation].[Case].[CMT_AGE] ) else ( 0 )
    Aggregate
    total total
    Rollup
    total total
    Average Age
    [Total Age - Awaiting Off Cycle] / [Awaiting Off Cycle - bin]
    Aggregate
    calculated calculated
    Rollup
    calculated calculated
    • Detail Filters
      2
    • Required
      [Presentation].[Sub Type].[SUB_TYPE_CODE] in ( 'ST-529', 'ST-938' )
    • Required
      [Presentation].[State].[NAME] in ('Assigned', 'Pending', 'Ready_To_Verify', 'Verified')
  • Query
    Active WIP - Pay Sheet Creation
    Data Items
    5
    All Cases
    count( [Presentation].[Case].[ID] )
    Aggregate
    total total
    Rollup
    total total
    Awaiting pay sheet creation - bin
    if ( [Presentation].[Case].[AWAITING_PAY_SHEET_CREAT] ='Yes/Oui') then (1) else (0)
    Aggregate
    total total
    Rollup
    total total
    Awaiting Pay Sheet Creation %
    total ([Awaiting pay sheet creation - bin] ) / total( [All Cases] )
    Aggregate
    calculated calculated
    Rollup
    calculated calculated
    Total Age - Awaiting Pay Sheet Creation
    if ([Awaiting pay sheet creation - bin] = 1 ) then ( [Presentation].[Case].[CMT_AGE] ) else ( 0 )
    Aggregate
    total total
    Rollup
    total total
    Average Age
    [Total Age - Awaiting Pay Sheet Creation] / [Awaiting pay sheet creation - bin]
    Aggregate
    calculated calculated
    Rollup
    calculated calculated
    • Detail Filters
      2
    • Required
      [Presentation].[Sub Type].[SUB_TYPE_CODE] in ( 'ST-529', 'ST-938' )
    • Required
      [Presentation].[State].[NAME] in ('Assigned', 'Pending', 'Ready_To_Verify', 'Verified')
  • Query
    Active WIP - Comp Sector
    Data Items
    5
    All Cases
    count( [Presentation].[Case].[ID] )
    Aggregate
    total total
    Rollup
    total total
    Waiting on Comp Sector - bin
    if ( [Presentation].[Case].[WAITING_ON_COMP_SECTOR] ='Yes/Oui') then (1) else (0)
    Aggregate
    total total
    Rollup
    total total
    Waiting on Comp Sector %
    total( [Waiting on Comp Sector - bin] ) / total ( [All Cases] )
    Aggregate
    calculated calculated
    Rollup
    calculated calculated
    Total Age - Waiting on Comp Sector
    if ([Waiting on Comp Sector - bin] = 1 ) then ( [Presentation].[Case].[CMT_AGE] ) else ( 0 )
    Aggregate
    total total
    Rollup
    total total
    Average Age
    total( [Total Age - Waiting on Comp Sector] ) / total( [Waiting on Comp Sector - bin] )
    Aggregate
    calculated calculated
    Rollup
    calculated calculated
    • Detail Filters
      2
    • Required
      [Presentation].[Sub Type].[SUB_TYPE_CODE] in ( 'ST-529', 'ST-938' )
    • Required
      [Presentation].[State].[NAME] in ('Assigned', 'Pending', 'Ready_To_Verify', 'Verified')
  • Query
    Active WIP - Documents
    Data Items
    5
    All Cases
    count( [Presentation].[Case].[ID] )
    Aggregate
    total total
    Rollup
    total total
    Waiting on documents - bin
    if ( [Presentation].[Case].[WAITING_ON_DOCUMENTS] ='Yes/Oui') then (1) else (0)
    Aggregate
    total total
    Rollup
    total total
    Waiting on Documents %
    total( [Waiting on documents - bin] ) / total( [All Cases] )
    Aggregate
    calculated calculated
    Rollup
    calculated calculated
    Total Age - Waiting on Documents
    if ([Waiting on documents - bin] = 1 ) then ( [Presentation].[Case].[CMT_AGE] ) else ( 0 )
    Aggregate
    total total
    Rollup
    total total
    Average Age
    total( [Total Age - Waiting on Documents] ) / total( [Waiting on documents - bin] )
    Aggregate
    calculated calculated
    Rollup
    calculated calculated
    • Detail Filters
      2
    • Required
      [Presentation].[Sub Type].[SUB_TYPE_CODE] in ( 'ST-529', 'ST-938' )
    • Required
      [Presentation].[State].[NAME] in ('Assigned', 'Pending', 'Ready_To_Verify', 'Verified')
  • Query
    Active WIP - HR
    Data Items
    6
    Case Number
    [Presentation].[Case].[ID]
    All Cases
    count( [Presentation].[Case].[ID] )
    Aggregate
    total total
    Rollup
    total total
    Waiting on HR - bin
    if ( [Presentation].[Case].[WAITING_ON_HR] ='Yes/Oui') then (1) else (0)
    Aggregate
    total total
    Rollup
    total total
    Waiting on HR %
    total( [Waiting on HR - bin] ) / total( [All Cases] )
    Aggregate
    calculated calculated
    Rollup
    calculated calculated
    Total Age - Waiting on HR
    if ( [Waiting on HR - bin] = 1 ) then ( [Presentation].[Case].[CMT_AGE] ) else ( 0 )
    Aggregate
    total total
    Rollup
    total total
    Average Age
    total( [Total Age - Waiting on HR] ) / total( [Waiting on HR - bin] )
    Aggregate
    calculated calculated
    Rollup
    calculated calculated
    • Detail Filters
      2
    • Required
      [Presentation].[Sub Type].[SUB_TYPE_CODE] in ( 'ST-529', 'ST-938' )
    • Required
      [Presentation].[State].[NAME] in ('Assigned', 'Pending', 'Ready_To_Verify', 'Verified')
  • Query
    Active WIP - Prior Case
    Data Items
    5
    All Cases
    count( [Presentation].[Case].[ID] )
    Aggregate
    total total
    Rollup
    total total
    Waiting on prior case completion - bin
    if ( [Presentation].[Case].[WAITING_ON_PRIOR_CASE_COM] ='Yes/Oui') then (1) else (0)
    Aggregate
    total total
    Rollup
    total total
    Waiting on Prior Case Completion %
    total( [Waiting on prior case completion - bin] ) / total( [All Cases] )
    Aggregate
    calculated calculated
    Rollup
    calculated calculated
    Total Age - Waiting on Prior Case Completion
    if ([Waiting on prior case completion - bin] = 1 ) then ( [Presentation].[Case].[CMT_AGE] ) else ( 0 )
    Aggregate
    total total
    Rollup
    total total
    Average Age
    total( [Total Age - Waiting on Prior Case Completion] ) / total( [Waiting on prior case completion - bin] )
    Aggregate
    calculated calculated
    Rollup
    calculated calculated
    • Detail Filters
      2
    • Required
      [Presentation].[Sub Type].[SUB_TYPE_CODE] in ( 'ST-529', 'ST-938' )
    • Required
      [Presentation].[State].[NAME] in ('Assigned', 'Pending', 'Ready_To_Verify', 'Verified')
Layouts