Queries

• 5
  Expressions:

  

  Data Items

  

  Detail Filters
• Model: /PCR/PCR Deployment/PCR Packages/packagePCR-RCP/ name: model

• 

  

  Last Valid Date

  Data Items

  1

  Latest Valid Load Date	[Presentation].[Data Load Archive].[Latest Valid Data Load Date]

• 

  

  Total Cases

  Data Items

  2

  Case Count	[Presentation].[Case].[Case Count]	Aggregate count
  For join	1

  • Detail Filters
    1
  • 

    [Presentation].[State].[NAME] in ('Assigned', 'Invalid', 'open', 'Pending', 'Ready_To_Verify', 'Reassigned', 'Triage_Follow-Up', 'Verified')
    
• 

  

  Main

  Data Items

  7

  State Name	[Presentation].[State].[NAME]	label VOLUME BY STATE NAME
  Case Count	[Presentation].[Case].[Case Count]	Aggregate count label # OF CASES
  Unique count of PRIs	[Presentation].[Case].[Unique count of PRIs]	Aggregate countDistinct
  Business Unit	[Presentation].[VW_STG_DEPARTMENT].[CODE]
  Age Group	[Presentation].[Case].[Age Group]	label VOLUME BY AGE GROUP
  Sub Type Name	[Presentation].[Sub Type].[NAME]
  Unique Class	[Presentation].[Case].[Subject]

  • Detail Filters
    3
  • 

    [Unique Class] = 'NU'
    
  • 

    [State Name] in ('Assigned', 'Invalid', 'open', 'Pending', 'Ready_To_Verify', 'Reassigned', 'Triage_Follow-Up', 'Verified')
    
  • 

    case
    when (?Dept? =1) then ([Business Unit] = 'AHS')
    when (?Dept? =2) then ([Business Unit] = 'NHW')
    end
    
• 

  

  Nurses Total

  Data Items

  4

  Business Unit	[Presentation].[VW_STG_DEPARTMENT].[CODE]
  Unique Class	[Presentation].[Case].[Subject]
  For join	1
  Active Nurses Cases	total( CASE WHEN ([Unique Class] ='NU' and ([Business Unit]= 'AHS' or [Business Unit]= 'NHW')) THEN (1) ELSE (0) END for report)

  • Detail Filters
    3
  • 

    [Presentation].[State].[NAME] in ('Assigned', 'Invalid', 'open', 'Pending', 'Ready_To_Verify', 'Reassigned', 'Triage_Follow-Up', 'Verified')
    
  • 

    case
    when (?Dept? =1) then ([Business Unit] = 'AHS')
    when (?Dept? =2) then ([Business Unit] = 'NHW')
    end
    
  • 

    [Unique Class] ='NU'
    
• 

  

  Percentage calc

  

  [Nurses Total].[For join ] = [Total Cases].[For join]

  

  Nurses Total

  1:1

  

  Total Cases

  1:1

  Data Items

  4

  Nurses	[Nurses Total].[Active Nurses Cases]
  Case Count	[Total Cases].[Case Count]	Aggregate summarize
  Percentage of global workload	round(([Nurses] / [Case Count]) * 100,2)
  Display if lower than 0.01	'< 0.01'

Layouts