Webi R2 - Report Requirement

building reports webintelligence
1

Hi All,

In my requirement,I need to calculate the List of people with valid employment status per every quarter,we get data quarterly.

The employment status indicator used is the most recent entered for the patient in the last 12 months.

Ex: Q3 Q4 Q1 Q2

Total Patients : 4452 4255 3800 2745
Valid Empl: 83 109 140 560

Note:

  1. Now in Q2 out of 2745 patients 560 are valid…But
    2.It should be more when we check valid Empl status for last 12 months for All the patients in Q2.
  2. Some of the patients from Q2(reporting quarter) will exist in last 3 quarters with valid EMPL but not in Q2(reporting quarter)…those needs to be counted.

I struck at how to count Q2 patients with valid Empl status in last 12 months…

Please let me know the possible ways to complete this …1

Cheers,
Paruchu

paruchuc :uk: (BOB member since 2009-09-18)

2

Hi paruchuc,

Try to use context operators when calculating a count.

like Count([Emp ID]) In ([Quarter]) or ‘Foreach’ depends on what your situation demands

Cheers

Ravee

ravi.bo :uk: (BOB member since 2009-09-01)