Your feedback drives the Concourse roadmap! Review and vote for existing ideas or submit new ideas.
For immediate technical support, please follow this guidance to open a Service Now ticket.
Dear team, could you add fields (columns) as below to the "Workspace Usage" tab in the "Delivery Excellence Adoption - Detailed" dashboard and populate values per workspace? This is a request from our management and is needed to visualize usage per workspace.
https://eu.workbench.pwc.com/report-viewer/shared/DEx_Adoption_Detailed
Please let us know if anything is unclear or if any field is difficult to obtain. Thank you in advance!
I attached the same table in ppt, so that it is easier to check.
# |
Field name |
Example |
Value |
Logic |
① |
Total users |
257 |
Users |
Total number of Jira users |
② |
Heavy users (≥80%) |
45 |
Users |
Use this ratio: "number of days when the user logged in" / "number of days that had logins" in the last 28 days Example) Environment XXX had 20 days when someone logged in, 45 users logged in 16 days or more (80% or more), 23 users logged in between 10 and 15 days (50-79%), 100 other users * These thresholds are our suggestion * “Idle users” implies “logged in at least once” |
③ |
Light users (50-79%) |
23 |
Users |
|
④ |
Idle users (<50%) |
100 |
Users |
|
⑤ |
Never-logged-in users |
89 |
Users |
Number of Jira users who never logged in |
⑥ |
Active user ratio |
26% |
Ratio |
(②+③)/① |
⑦ |
Average daily login frequency |
200 |
Times per day |
“Total number of logins” / “number of days that had logins” in the last 28 days *Count the number of logins as total of all users’ logins on occurrence basis (4 times in 1 day equals 4 logins even if it was only one user) |
⑧ |
Average daily login frequency per active user |
2.9 |
Times per user per day |
⑦/(②+③) |
⑨ |
Total Jira issues |
520 |
Issues |
Total number of issues created in Jira |
⑩ |
“To Do" Jira issues |
280 |
Issues |
Number of issues where status category is “To Do” |
⑪ |
"In Progress" Jira issues |
60 |
Issues |
Number of issues where status category is “In Progress” |
⑫ |
“Done" Jira issues |
180 |
Issues |
Number of issues where status category is “Done” |
⑬ |
Issue update ratio |
46% |
Ratio |
(⑪+⑫)/⑨ |
⑭ |
Average daily issue update frequency |
70 |
Times per day |
“Total number of updated issues” / “number of days that had logins” during the last 28 days *Count updated issues on user by issue by day basis (even if the same user changes the same issue several times during the same day, count as 1) |
⑮ |
Average daily issue update frequency per active user |
1 |
Times per user per day |
⑭/(②+③) |