LinkedIn
Twitter
I am using Looker (not the Studio) to pull data from a Jira cloud instance that has several scrum projects.
Each story in a project belongs to a sprint.
Each story has Story Points (empty or a number >= 0).
I created a Look that pulls these columns from Jira:
- Project name
- Sprint name
- Issue key
- Story Points
In addition, I created a custom field (measure) called 'Completed Story Points' which evaluates to the Story Points value if the issue status is Done, else it's set to 0.
I then set the sprint name to be a pivot, and in the table visualization I turned on Totals.
So, for each sprint (which is 3 columns in the table) I get, in the column totals, the sum of the column Story Points ('SPs') as 31.6 and the sum of the column Completed Story Points ('CSPs') as 29.1. They are not the same value because some stories in the sprint are not yet Done.
What I'm trying to achieve is to calculate and display the ratio of CSPs/SPs - for this sprint it's 29.1/31.6 -> 92%.
Any idea?
