1 Reply Latest reply: Dec 4, 2017 12:09 PM by Sunny Talwar RSS

    Selections

    Sofia Vaz

      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

        • Re: Selections
          Sunny Talwar

          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))