Data Summarizing in table

building reports webintelligence
1

Hello,

I have a table and i want to summarize the data, but cannot do it.
My table is :
OPEN CLOSE PRIORITY COUNT
NO YES 1 19
NO YES 2 72
NO YES 3 115
YES NO 1 17
YES NO 2 20
YES NO 3 96
YES YES 1 53
YES YES 2 111
YES YES 3 165

As a result, I want a table with 3 columns (ACTION, PRIORITY, COUNT) summarized like follow :

  • ACTION
    = OPEN (if OPEN = YES)
    = OPEN/CLOSE (if OPEN = YES and CLOSE = YES)
    = CLOSE (if CLOSE = YES)
  • PRIORITY
  • COUNT = sum of values for each action/priority

The final table should be :
ACTION PRIORITY COUNT
OPEN 1 70
OPEN 2 131
OPEN 3 261
OPEN/CLOSE 1 53
OPEN/CLOSE 2 111
OPEN/CLOSE 3 165
CLOSE 1 72
CLOSE 2 183
CLOSE 3 280

I hope my explanation is clear enough :smiley:

Thank you in advance to all
Atxeco[/code]

atxeco (BOB member since 2009-05-13)

2

Create variable like follows::



=If[Open]= "NO" then "CLOSE" ElseIf[Open]="Yes" and [close]="Yes" then "OPEN/CLOSE" Else "OPEN"

Thanks

BOCP (BOB member since 2007-07-02)

3

Thank you for your answer, but it does not work. Indeed, an OPEN/CLOSED must summarized as OPEN, OPEN/CLOSED and CLOSED, not only in OPEN/CLOSED.
All OPEN muste be summarized in OPEN, and if CLOSED, summarized in OPEN/CLOSED and in CLOSED. Same for CLOSED.

I hope i make it clearer :slight_smile:

Atxeco

atxeco (BOB member since 2009-05-13)

4

I’m not getting about your requirement. Can you explain it step by step like open will appear when ---------------------- and etc…,

Thanks

BOCP (BOB member since 2007-07-02)

5

It’s quite difficult to explain, but i’ll try to make it as simple as possible.

I have “solves” with an OPEN date and a CLOSE date.
I want to summarize the number of “solves” opened last month (regardless they are close or not), open/closed last month and closed last month (regardless the open month)
For example :
Solve open : 03/2009 closed 04/2009
Solve open : 04/2009 closed 04/2009
Solve open : 04/2009 not closed
Solve open : 04/2009 closed 05/2009

For reporting on 04/2009, i shoud get :
OPEN : 3
OPEN/CLOSED : 1
CLOSED : 2

If I use the variable you gave me, the result would be something like (regarding in whioch order I built te variable) :
OPEN : 2
OPEN/CLOSED : 1
CLOSED : 1
which is not what I need

Atxeco

atxeco (BOB member since 2009-05-13)