I want to see each team members original estimated times totally in current sprint.
I use this query but I can't group it by "assignee" to reach the total original estimated time by each person. unfortunately, pie chart shows the result by count of issue type but I need by sum of original estimate.
project in (XXX) AND Sprint in openSprints() AND issuetype = Sub-task
You don't. There's a couple of reasons -
First, sub-tasks do not have sprint estimates, because they're not sprint-items themselves, they are a part of their parent.
Second, sub-tasks do not have a sprint, because they are part of a story and hence "in a sprint" as part of the story. There's a weakness in Jira in that it does not cascade that down, so "issue type in subtasktypes and sprint = X" is never going to find any sub-tasks, but even if it were to work, the sprint would still be set by the parent. You'll need to infer the sub-task list from the list of stories in the sprint.
For JSM June Challenge #2, share how your non-technical teams like HR, legal, marketing, finance, and beyond started using Jira Service Management! Tell us: Did they ask to start using it or...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events