Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
I am using aggr function within sum function as shown in the below expression. The problem is, since I am using "if" statement, the bar chart some how doesn't display the data until I choose a value in field, "F1". After using aggr function this problem is eliminated and the graph displays value even without making a selection in "F1". But now when I choose one particular week, data displayed is right, but if I choose more than one week, expression sums up for both the weeks and displays it as just one bar as shown in the below screenshot. I would want to see % values for how many ever weeks I choose. So here when I choose week1 and week2, % values for both the weeks should be visible in the graph. How do I do this?
Expression:
=(sum(aggr(if(F1='ONLine',sum({$<F1={"ONLine"},Station={"BMM"}>}"Operating Time
if(F1='OFFLine',sum({$<F1={"OFFLine"}>}"Operating Time
*sum({$<F1={"OFFLine"}>}"Planned Prod. Time
)*sum({$<Station={"BMM"}>}"Planned Prod. Time
Any suggestion?
Thank you.
Hi Sunny,
Yes, it works! Could you please explain what this first "IF" condition here about dimensionality does here?
Thank you.
Check here to see how dimensionality works
Sure. Thanks!