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.

       

      Chart_1.png

       

      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.