TEAM Column in AIO

Question

Hello

I have imported all columns in Tableau using the AIO Connector for JIRA.

I have got all data perfectly fine but when I pull Team i dont see team name instead I see numbers.

I am able to get all columns except the Teams. Can you please help me find the exact column?

Are these the only Tables I can import from AIO Connector ?

Amit Naik · Answer

I am able to get all fields via Web Connector however I am not able the get the Team Column in Tempo isnt the one which contains my Team info. SO was wondering where this Team column might be

Common
Description
Description
Issue Type
Issue Type
Key
Key
Labels
Labels
Priority
Priority
Resolution
Resolution
Status
Status
Status Category
Status Category
Summary
Summary

Users
Assignee
Assignee
Business Owner
Business Owner
Creator
Creator
Developer
Developer
Front-end Developer
Front-end Developer
PM Name
PM Name
QA Analyst
QA Analyst
Reporter
Reporter
Requestor
Requestor
Reviewer
Reviewer
SD Customer
SD Customer
SOW Author
SOW Author

Dates
Close Date
Close Date
Created
Created
Date SOW Sent to Client
Date SOW Sent to Client
Date SOW Signed by Client
Date SOW Signed by Client
Due Date
Due Date
Last Viewed
Last Viewed
Requested Delivery Date
Requested Delivery Date
Resolved
Resolved
Response Date
Response Date
Satisfaction date
Satisfaction date
Start Date
Start Date
Target Delivery Date
Target Delivery Date
Target End Date
Target End Date
Task Date
Task Date
Updated
Updated

Worklogs
Time Entry Date
Time Entry Date
Time Entry Description
Time Entry Description
Time Entry Hours (hrs)
Time Entry Hours (hrs)
Time Entry User
Time Entry User
Time Entry Userkey
Time Entry Userkey
Time Entry Username
Time Entry Username
Worklog ID
Worklog ID

Parent Issue
Parent Issue Key
Parent Issue Key
Parent Issue Priority
Parent Issue Priority
Parent Issue Status
Parent Issue Status
Parent Issue Summary
Parent Issue Summary
Parent Issue Type
Parent Issue Type

Sprint
Sprint Complete Date
Sprint Complete Date
Sprint End Date
Sprint End Date
Sprint Id
Sprint Id
Sprint Name
Sprint Name
Sprint Sequence
Sprint Sequence
Sprint Start Date
Sprint Start Date
Sprint State
Sprint State

Epic
Epic Colour
Epic Colour
Epic Link
Epic Link
Epic Name
Epic Name
Epic Status
Epic Status

Project
Project Category
Project Category
Project Description
Project Description
Project Key
Project Key
Project Lead
Project Lead
Project Name
Project Name
Project Type
Project Type

Fix Version
Fix Version Archived
Fix Version Archived
Fix Version Description
Fix Version Description
Fix Version Name
Fix Version Name
Fix Version Release Date
Fix Version Release Date
Fix Version Released
Fix Version Released
Fix Version Start Date
Fix Version Start Date

Service Desk
Commented -24h
Commented -24h
Commented -24h (millis)
Commented -24h (millis)
Commented -24h Breached?
Commented -24h Breached?
Commented -24h Target (millis)
Commented -24h Target (millis)
Customer Request Type
Customer Request Type
Customer Time for Validation
Customer Time for Validation
Customer Time for Validation (millis)
Customer Time for Validation (millis)
Customer Time for Validation Breached?
Customer Time for Validation Breached?
Customer Time for Validation Target (millis)
Customer Time for Validation Target (millis)
Organizations
Organizations
Request participants
Request participants
Request Status
Request Status
Request Status Date
Request Status Date
Tier 1 SLA - Status Updates
Tier 1 SLA - Status Updates
Tier 1 SLA - Status Updates (millis)
Tier 1 SLA - Status Updates (millis)
Tier 1 SLA - Status Updates Breached?
Tier 1 SLA - Status Updates Breached?
Tier 1 SLA - Status Updates Target (millis)
Tier 1 SLA - Status Updates Target (millis)
Tier 1 Time to First Response
Tier 1 Time to First Response
Tier 1 Time to First Response (millis)
Tier 1 Time to First Response (millis)
Tier 1 Time to First Response Breached?
Tier 1 Time to First Response Breached?
Tier 1 Time to First Response Target (millis)
Tier 1 Time to First Response Target (millis)
Tier 2 Done
Tier 2 Done
Tier 2 Done (millis)
Tier 2 Done (millis)
Tier 2 Done Breached?
Tier 2 Done Breached?
Tier 2 Done Target (millis)
Tier 2 Done Target (millis)
Tier 2 Time to First Response
Tier 2 Time to First Response
Tier 2 Time to First Response (millis)
Tier 2 Time to First Response (millis)
Tier 2 Time to First Response Breached?
Tier 2 Time to First Response Breached?
Tier 2 Time to First Response Target (millis)
Tier 2 Time to First Response Target (millis)
Time to first response
Time to first response
Time to first response (millis)
Time to first response (millis)
Time to first response Breached?
Time to first response Breached?
Time to first response Target (millis)
Time to first response Target (millis)
Time to resolution
Time to resolution
Time to resolution (millis)
Time to resolution (millis)
Time to resolution Breached?
Time to resolution Breached?
Time to resolution Target (millis)
Time to resolution Target (millis)
Time waiting for support
Time waiting for support
Time waiting for support (millis)
Time waiting for support (millis)
Time waiting for support Breached?
Time waiting for support Breached?
Time waiting for support Target (millis)
Time waiting for support Target (millis)

Issue Effort
Original Estimate (hrs)
Original Estimate (hrs)
Original Estimate (Incl. Sub-tasks) (hrs)
Original Estimate (Incl. Sub-tasks) (hrs)
Remaining Estimate (hrs)
Remaining Estimate (hrs)
Remaining Estimate (Incl. Sub-tasks) (hrs)
Remaining Estimate (Incl. Sub-tasks) (hrs)
Time Spent (hrs)
Time Spent (hrs)
Time Spent (Incl. Sub-tasks) (hrs)
Time Spent (Incl. Sub-tasks) (hrs)

Story Points
Story Points
Story Points
Story Points Completed
Story Points Completed
Story Points Remaining
Story Points Remaining

Custom
Acceptance Criteria
Acceptance Criteria
Actual Cost ($)
Actual Cost ($)
Actual Results
Actual Results
Application / System(s)
Application / System(s)
Approvers
Approvers
Ballpark Estimate
Ballpark Estimate
Benefit Justification
Benefit Justification
Billing Status
Billing Status
Blended Resource Rate ($)
Blended Resource Rate ($)
Brand
Brand
Brand/s Provided
Brand/s Provided
BRD Use Case ID
BRD Use Case ID
Browser
Browser
Business Benefit (Estimated $)
Business Benefit (Estimated $)
Business Benefit(s) Realized?
Business Benefit(s) Realized?
Business Driver
Business Driver
Business Impact
Business Impact
Business Sponsor
Business Sponsor
Business Sponsor(s)
Business Sponsor(s)
Call Center
Call Center
Capex (Estimated $)
Capex (Estimated $)
Capex (Total $)
Capex (Total $)
Capitalizable
Capitalizable
Change Order Status
Change Order Status
Client / Brand
Client / Brand
Client Lead
Client Lead
Client Priority
Client Priority
Client Request Category
Client Request Category
Client Severity
Client Severity
Client Sponsor
Client Sponsor
Company Name Provided
Company Name Provided
Cost Estimate ($)
Cost Estimate ($)
Cost Justification (Analytics)
Cost Justification (Analytics)
Defect Area
Defect Area
Digital Sponsor(s)
Digital Sponsor(s)
Division
Division
Error Type
Error Type
Estimated CapEx $ (Analytics)
Estimated CapEx $ (Analytics)
Estimated LOE
Estimated LOE
Estimated OpEx $ (Analytics)
Estimated OpEx $ (Analytics)
ETC Hours
ETC Hours
ETC Spend
ETC Spend
Executive Report
Executive Report
Expected Benefit
Expected Benefit
Expected Results
Expected Results
Expense Type
Expense Type
Flagged
Flagged
Freshservice Tickets
Freshservice Tickets
Health
Health
Hours (BI)
Hours (BI)
Hours (Commerce Systems)
Hours (Commerce Systems)
Hours (Corporate Systems Applications)
Hours (Corporate Systems Applications)
Hours (Digital)
Hours (Digital)
Hours (Fulfillment Systems)
Hours (Fulfillment Systems)
Hours (NetOps)
Hours (NetOps)
Hours (Others)
Hours (Others)
Hours (PMO)
Hours (PMO)
Hours (QA)
Hours (QA)
Hours (Total Estimated Labor)
Hours (Total Estimated Labor)
Hours (Total Labor)
Hours (Total Labor)
Impact Detail
Impact Detail
Impacted Functionality
Impacted Functionality
Importance
Importance
Initiative Cost (Estimated $)
Initiative Cost (Estimated $)
Initiative Cost (Total $)
Initiative Cost (Total $)
Issue Frequency
Issue Frequency
Issue Location
Issue Location
issueFunction
issueFunction
IT Sponsor(s)
IT Sponsor(s)
jqltField
jqltField
Labor Cost (Estimated $)
Labor Cost (Estimated $)
Labor Cost (Total $)
Labor Cost (Total $)
Location
Location
Misc. Cost (Estimated $)
Misc. Cost (Estimated $)
Non-Labor Cost (Estimated $)
Non-Labor Cost (Estimated $)
Non-Labor Cost (Total $)
Non-Labor Cost (Total $)
OCX Ticket
OCX Ticket
OMF ID
OMF ID
OMX Key ID
OMX Key ID
Opex (Estimated $)
Opex (Estimated $)
Opex (Total $)
Opex (Total $)
Order Motion Comments
Order Motion Comments
Other Cost (Total $)
Other Cost (Total $)
Pending
Pending
Product Owner
Product Owner
Product Owner Priority
Product Owner Priority
Public Status
Public Status
Rank
Rank
Rank (Obsolete)
Rank (Obsolete)
Regulatory Requirements
Regulatory Requirements
Release Version History
Release Version History
Reporter Email Domain
Reporter Email Domain
Requested by Client(s)
Requested by Client(s)
Resolver Group
Resolver Group
Revenue Estimate ($)
Revenue Estimate ($)
Revenue Generated / Amount Billed ($)
Revenue Generated / Amount Billed ($)
Risk
Risk
ROI (%)
ROI (%)
Root Cause
Root Cause
Root Cause / Fix Implemented
Root Cause / Fix Implemented
Runbook/s Used
Runbook/s Used
SCRUM Team
SCRUM Team
Service Request Type
Service Request Type
Severity
Severity
SOW
SOW
SOW Hours
SOW Hours
SOW Notes
SOW Notes
SOW Status
SOW Status
Spend to Date
Spend to Date
Status Update(s)
Status Update(s)
Steps to Reproduce
Steps to Reproduce
Teams Involved
Teams Involved
Test Account
Test Account
TestRail
TestRail
TFS ID
TFS ID
Ticket Category
Ticket Category
Time in Status
Time in Status
Time of Occurrence
Time of Occurrence
Topic
Topic
URL
URL
User(s) Affected
User(s) Affected
Vendor Cost (Estimated $)
Vendor Cost (Estimated $)
Vendor Cost (Total $)
Vendor Cost (Total $)
VIP Ticket
VIP Ticket
Workstation ID
Workstation ID

History
History Author
History Author
History Field
History Field
History New Value
History New Value
History Old Value
History Old Value
History Value End
History Value End
History Value Start
History Value Start
Sequence
Sequence

Other
Affects Version/s
Affects Version/s
Comment
Comment
Component/s
Component/s
Environment
Environment
Linked Issues
Linked Issues
Sub-Tasks
Sub-Tasks
Votes
Votes
Watchers
Watchers
Work Ratio
Work Ratio

Tempo
Account
Account
Iteration
Iteration
Team
Team

Time with Assignee
Assignee end
Assignee end
Assignee sequence
Assignee sequence
Assignee start
Assignee start
Assignee with sequence
Assignee with sequence
History Assignee
History Assignee
Time with assignee (business days)
Time with assignee (business days)
Time with assignee (business hrs)
Time with assignee (business hrs)
Time with assignee (days) (days)
Time with assignee (days) (days)
Time with assignee (hrs) (hrs)
Time with assignee (hrs) (hrs)

Time in Status
History Status
History Status
Status end
Status end
Status sequence
Status sequence
Status start
Status start
Status with sequence
Status with sequence
Time in status (business days)
Time in status (business days)
Time in status (business hrs)
Time in status (business hrs)
Time in status (days) (days)
Time in status (days) (days)
Time in status (hrs) (hrs)
Time in status (hrs) (hrs)

Amit Naik · Answer

Thank you so much for replying me and for your kind help.

The AIO Connector is already there and I am able to pull all the columns with data. However its jut this specific column I am looking for which is not available via the Web Connector.

JP _AC Bielefeld Leader_ · Answer

Hi Amit,

did you ask the company creating the AIO connector? As this is a pretty specific addon I would either ask them or Tempo directly.

Best

JP