4 Replies Latest reply: Oct 5, 2015 6:16 PM by Marco Wedel

# Stacked Bar Chart

Hello all,

I am trying to make this bar chart:

The escapes and catches each have two different expressions, so it is not working properly.

The escape's definition is: if(DEPT<>F_DEPT,SUM(REJECT_QTY))

Whereas the Catches definition is if(DEPT=F_DEPT,SUM(REJECT_QTY)).

Does anyone know how to do this?

• ###### Re: Stacked Bar Chart

Hi,

please post sample data/app to demonstrate with.

regards

Marco

• ###### Re: Stacked Bar Chart

SUM( if(DEPT<>F_DEPT,REJECT_QTY))

SUM( if(DEPT=F_DEPT,REJECT_QTY))

• ###### Re: Stacked Bar Chart

Hi, Channing Dionisopoulos.

Try

Escape = Sum({<DEPT = {"=Sum(if(DEPT <> F_DEPT,REJECT_QTY))"}>} REJECT_QTY)

Catch = Sum({<DEPT = {"=Sum(if(DEPT = F_DEPT,REJECT_QTY))"}>} REJECT_QTY)

Hope this helps!

• ###### Re: Stacked Bar Chart

Hi,

possible solutions could be also:

• calculated dimension

• Expressions using set expressions instead of If() conditions:

hope this helps

regards

Marco