1 Reply Latest reply: Apr 17, 2017 1:15 PM by Justin Dallas RSS

    Data disappears on Year selection

    Justin Dallas

      Hello Everyone,


      I've got a strange issue whereby my data is disappearing from my chart when I select a year.  With nothing selected, the Max(Year) =2017 and I get a chart like this.




      If you look to the right, you can see that I've got a spot for the result of Max(Year) - 1 and Max(Year).  However,  as soon as I select the Year [2017] from a filter list, all of the data that should show based on Max(Year) - 1 disappears.

      My bar chart Expressions look like this


      Sum({<Year = {$(=max(Year))}>} [Stop Leg Mileage])

      for the current year, and


      Sum({<Year = {$(=max(Year)-1)}>}  [Stop Leg Mileage])

      for the previous year.



      Generally, when data falls away, it means that you haven't linked in correctly, but I've verified that the data does exist.


      Any help is greatly appreciated.

        • Re: Data disappears on Year selection
          Justin Dallas

          The data does appear when I add a '1' to the front of my Set Analysis.  I went from


          Sum({<Year = {$(=max(Year)-1)}>} [Stop Leg Mileage])


          to Sum({1<Year = {$(=max(Year)-1)}>} [Stop Leg Mileage])


          and it works fine.  I guess what was happening was that when the Year was selected, the data pertaining to 'Year-1' was excluded.  The 1 tells the system to ignore the Year selections made by the user.