Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all.
I have a line chart that shows the service level from the first week of the year to the last complete week. This is the expression:
Count({$<MillAlloc={"ATF"},AllocWeekYear={"<=$(vLastAllocWeek)"}, InternalServPfeYn={"N"},InternalServExternalPi={"N"},InternalServReadyLateDisp={"Y"}>}InternalServReadyLateDisp)
/(Count({$<MillAlloc={"ATF"},AllocWeekYear={"<=$(vLastAllocWeek)"}, InternalServPfeYn={"N"},InternalServExternalPi={"N"}>}InternalServReadyLateDisp))
I also have different filter panes in order to make my analysis. Everything is ok, except for some filters that, when actionated, make the chart shown values for entire year (including weeks that have not occurred yet).
What can I do more in order to force the chart to display values only until when I want?
Do you have any idea what I might be doing wrong?
Thank you!
Sofia Vaz
May be adding a equal sign might helps
Count({$<MillAlloc={"ATF"},AllocWeekYear={"<=$(=vLastAllocWeek)"}, InternalServPfeYn={"N"},InternalServExternalPi={"N"},InternalServReadyLateDisp={"Y"}>}InternalServReadyLateDisp)
/(Count({$<MillAlloc={"ATF"},AllocWeekYear={"<=$(=vLastAllocWeek)"}, InternalServPfeYn={"N"},InternalServExternalPi={"N"}>}InternalServReadyLateDisp))