3 Replies Latest reply on Sep 19, 2018 8:37 PM by Tushar More

    LONGITUDINAL ANALYSIS

    Toby Bernhagen

      Good Morning

       

      I was hoping for some guidance.

       

      I have been reading through some blogs to develop my tableau skills and have come across Steve's great site. I am currently looking at the blog "Showing Now vs Then" which has been awesome.

       

      https://www.datarevelations.com/showing-now-versus-then.html

       

      And this is what I have so far

       

       

      Now the data set I am playing with has data going back a decade. The description pill contains the questions. However not all questions appear each year so what I would like to do is have a filter that only shows the questions that appear in both the current year filter and the prior year.

       

      Is this kind of calculated field possible? If so how do I make it show the questions that only appear in both years.

       

      Thank you.

       

      And for those really observant people yes I do have an issue regarding the color not working right too, but I am looking at that at the moment.