2 Replies Latest reply: Sep 29, 2011 9:41 PM by Padma Tummala

# How to do Selective Count in WebI Report

Currently Being Moderated

Hi

I need to perform following task in Webi Report. I have a group of participants belonging to different age groups, the participants are distributed among 4 programs. I need to plot a graph with programs against participants. for this i need to differentiate the participants into  three age groups <12, 12-15 and >15. Please let me know how to selectively count age of the participants and group into these categories. Then, I want to plot youth service programs on X axis and age vertical stacked on the Y axis.

• ###### Re: How to do Selective Count in WebI Report
Currently Being Moderated

Let's suppose this is your data:

participant     age

mary kate     12

paisley ann     15

klea lorraine     17

aslan john     13

jonas louis     12

mark caspian16

yancy marie     11

1- Create a table using participant dimension and age measure.

2- Add a third column and palce this formula in the third column:

` =If [age]<12 Then "group<12" Else If [age] >= 12 And [age]<=15 Then "group 12-15 " Else If [age]>15 Then "group >15"`

3- Your table should look like this:

then, on third column formula, press Create Variable button.

Name: my formula column

Qualification:dimension

Press Ok

4 - Now create a second table. it should have to columns. In the first one insert your new object 'My column formula'. In the second column insert this formula :

` =Count([participant])  `

press Create Variable button.

Name this formula: my age participant count.

Qualification: measure

You can see it counts all the partipants according to their age range classification.

5 - Convert this table into a graph or insert an empty graph and drag 'My column formula' in x axis and 'my age participant count' measure in y axis

regards

Erika

Edited by: PadawanGirl on Sep 26, 2011 11:14 PM

Edited by: PadawanGirl on Sep 26, 2011 11:25 PM

• ###### Re: How to do Selective Count in WebI Report
Currently Being Moderated

Thanks for the reply. It solved my issue, I could create the graph. I have an update though, here is the IF ELSE IF syntax I used.

( [AGE]<12;"<12";IF([AGE] BETWEEN(12;15);"12-15";">15") )