Forum Discussion

Kay_Kalu's avatar
Kay_Kalu
Helper I
10 months ago
Solved

Matrix table

In the image below how do I get the Jira Id in a matrix table row to capture all the rework feedback and not just the First or Last    
Need Help
Tips and Tricks
  • SamWiseOwl's avatar
    SamWiseOwl
    10 months ago

    Hi Kay_Kalu 

     

    Assuming you want to use a measure in a Matrix visual and the JiraID within the Rows section:

    Create a new measure

    All Feedback = 
    ConcatenateX(
                       'You table name' --table name
                       ,[rework_feedback] --the data you want to show

                       ,", " --Seperator in list

                       , [Comment date] --Column to sort by

                       ,Desc --sort direction

    )

    Hope this helps 🙂

SamWiseOwl's avatar
SamWiseOwl
Super User
10 months ago

Hi Kay_Kalu 

 

Assuming you want to use a measure in a Matrix visual and the JiraID within the Rows section:

Create a new measure

All Feedback = 
ConcatenateX(
                   'You table name' --table name
                   ,[rework_feedback] --the data you want to show

                   ,", " --Seperator in list

                   , [Comment date] --Column to sort by

                   ,Desc --sort direction

)

Hope this helps 🙂