Hi Kevin - I'm glad you're finding the group helpful! We're just starting out, so it's good to hear that we're making a difference. Small but might! :-)
I don't work with repeating inputs like you've got in your survey, so somebody else might have a better answer -- but I wonder if you're capturing the date for each response and could look at them that way? You'd still need some kind of calculation to only count if different, but that might help with your double-counting.
As I said, I'm sure there will be better answers than mine. :-)
Thanks for participating in the group!
Kevin, it will all depend on how your viz is laid out and you data structured, you can defininity use a table calculation to lookup the current answer, compare to to a previous answer and only return it if they are not equal. Post a package workbook and we can help you work it out.
Apologies for the delayed post. Thank you for the feedback. I have posted a packaged workbook with fictitious data that is reshaped in Excel (Tableau AI), I think, explains my dilemma. As you will see each respondent has the potential to complete the questionnaire multiple times. If you look closer some years they answer a question Y and the the following year they list a Y as well for the same question. From a counting perspective I am not concerned with the 2nd Y. Ultimately, here is my major question.
1. Calculated field/Table Calculation to show ONLY the first Y answer. This is where I think it will get difficult as the these situations vary throughout the annual responses. I imagine this will involve IF,THEN?
Again, thank you for any feedback that you may have.
SamplePWB1.twbx 33.7 KB