Customizer Script to report User key information using User Work Logged by Date gadget in the Dataplane app

This article helps you to find the unique User key in the dataset using the User Work Logged by Date gadget.

Steps

1. Login to Jira. Navigate to the Dataplane Report app, then select Reports.

2. Select the "User Work Logged by Date" report.

3. Select a Monthly time interval.

4. Search Projects, Categories, Boards, and Filters, or use JQL as needed.
   
   

   Open

   

    

5. Compose the script below to obtain results based on user key data.
   
   

   Open

   

    

   customizeResult { Matrix matrix = getMatrix(); def workedByCol = getColumn("Work Logged By") def NEW_COLUMN_NAME = "Userkey" def NEW_COLUMN_INDEX = matrix.getIndexOfColumn(getColumn("Work Logged By")) + 1; addColumn(NEW_COLUMN_NAME, DataColumnType.TEXT, NEW_COLUMN_INDEX) { row, col -> def workLoggedByUserkey = matrix.getValue(row.getRowNum(), workedByCol) return workLoggedByUserkey } }

    

6. Run the report to get the desired result.
   
   

7. Navigate to Data to view the data in the result.