Forum Discussion
B_Real
Advocate IV
Advocate IVRepeating rows in a table, show only first row
In a table visualisation, repeating rows will include the value on every row, such as this: Here there are 7 questions in a Care Profile Assessment. Repeating 'Care ...
You can use "Matrix" visual instead of "Table"
Greg_Deckler
Community Champion
Community ChampionYou could create a measure like:
QuestionNumberMin = MIN([QuestionNumber])
And use that in place of your QuestionNumber column.
B_RealSorry 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.
