Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Please adjust your expressions and set "stacked" at Style tab
SUM( if(DEPT<>F_DEPT,REJECT_QTY))
SUM( if(DEPT=F_DEPT,REJECT_QTY))
Hi,
please post sample data/app to demonstrate with.
regards
Marco
Please adjust your expressions and set "stacked" at Style tab
SUM( if(DEPT<>F_DEPT,REJECT_QTY))
SUM( if(DEPT=F_DEPT,REJECT_QTY))
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!
Hi,
possible solutions could be also:
reducing your expression to simply
hope this helps
regards
Marco