0 Replies Latest reply on Jul 12, 2018 11:09 AM by dylan cruise

    Detail gets right value but Lookup does not "see" it

    dylan cruise

      I am blending across multiple data sources and need to compare the Current Time Period to the Previous Time Period. The time periods are built off of a parameter (Rolling 12 months, Fiscal year To Date, etc) so it isnt as simple as looking across a year. I need to subtract the Previous Time value from the Current Time value to determine how much it has changed. I have "Trend Date Filter" which checks it is the current time. When i put this on the Detail marks card, it gets the correct value. But the previous time value is not correct. I then add the "Previous Trend Date Filter" on to the detail, and I get the correct Previous Time value. Unfortunately my lookup then breaks and I cannot get the value to compare.


      I am having a tough time explaining this in text so hopefully pictures will work.

       

       

       

       

      1.PNG

      2.PNG