Stacked Bar Chart

[#1]

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?

[MarcoWedel]

‌Hi,

please post sample data/app to demonstrate with.

regards

Marco

[Clever_Anjos · Accepted solution]

Please adjust your expressions and set "stacked" at Style tab

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

SUM( if(DEPT=F_DEPT,REJECT_QTY))

[jonas_rezende]

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!

[MarcoWedel]

Hi,

possible solutions could be also:

• calculated dimension

reducing your expression to simply

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

hope this helps

regards

Marco