3 Replies Latest reply on Aug 10, 2018 4:43 AM by Jim Dehner

    Using LOOKUP() Excluding Nulls in Next Column

    Eleanor Jarvis

      Hi,

       

      I have a dashboard that is comparing three years of survey data. In the dashboard I have four columns:

       

      1) Direction of Travel (difference % agree to question from previous survey)

      2) Difference % agree to question from the sector

      3) % Agree to question

      4) Sector % Agree

       

      The problem that I am having, is that Question 2 was not included in the survey in 2016. Therefore the difference from the previous year in the 2017 column is showing as +98, which is the value for % Agree in that year. This is skewing all of my bars for that chart, and is not really an accurate representation of the data. When I tried to filter out large values for this column, all of the other measures were also filtered.

       

      Is there a way that I can show this information correctly (i.e. no difference when the question was not asked previously)?

       

      I've attached a dashboard with dummy data.

       

      Thanks in advance!

       

      Eleanor