Forum Discussion
Advocate IVRepeating rows in a table, show only first row
You can use "Matrix" visual instead of "Table"
Community ChampionYou could create a measure like:
QuestionNumberMin = MIN([QuestionNumber])
And use that in place of your QuestionNumber column.
Advocate IVSorry I should probably have mentioned that I need to display the answers to every question, which are in a separate column not shown in my original image, like this:
Apologies my first post should have been clearer. So a min won't work, because I need to show the question number and the question itself. So in my example, Name and Created Date' would only appear on the first row alongside QuestionNumber 1.
In Tableau it removes the repeating values automatically.
hohlickContinued Contributor
You can use "Matrix" visual instead of "Table"
- B_Real
Haha, sometimes the simplist of solutions are the best! How did I not see that... cheers hohlick!
Coming in very late on this, but I have tried this solution using the matrix visual and it is not working. Has this visual been updated since the last post here? The matrix wants to make me drill down to the next field, instead of displaying them in different columns. I found a link from a stackoverflow.com post about the same topic. There are a few images near the bottom of the post showing a table and a matrix visualization. I can't get my matrix to look anything like that, but that is exactly what I am trying to do...
