Forum Discussion

IF's avatar
IF
Post Prodigy
5 years ago

waterflow chart with calculation

Hi,

I want to make a very difficult waterfall chart from the following table:

Name

Type1

Type2

Type3

S

C

D

A

TBD

a1

A

#

P

1

  

1

 

a2

B

#

P

1

  

1

 

a3

C

#

B

1

  

1

 

a4

#

Y

N

1

1

 

1

 

a5

#

Y

N

1

1

 

1

 

a6

A

#

N

1

  

1

 

a7

#

Y

N

1

1

 

1

 

a8

B

#

P

1

  

1

 

a9

A

#

P

1

  

1

 

a10

A

#

N

1

  

1

 

a11

#

Y

O

 

1

1

  

a12

#

#

O

  

1

  

a13

#

Y

N

1

1

 

1

 

a14

B

#

P

1

  

1

 

a15

#

Y

O

 

1

1

  

a16

A

#

P

1

  

1

1

a17

A

#

P

1

  

1

1

a18

#

Y

N

1

1

 

1

 

a19

B

#

P

1

  

1

 

a20

C

#

N

  

1

  

 

I consider the count of each row and the result is:

 

S

C

D

A

TBD

Count

16

7

4

16

2

 

And I want to make the following chart:

The waterfall chart has 8 steps. It starts and ends with S column. Green is  count of C column, red is shown as decrease. Purpol (A column) doesn't have any relationship with the previous ones. It is just reflection of count of column A.  Second red column is TBD column and it is decrease. Blue column is a calculation column, based on A-TBD result, which is X. Yellow (Y value) is X-S. At the end S column is repeated.

 

I hope I can find a solution for this.

All the best

Need Help

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

    I think you are talking about two separate waterfall charts.