Hi all
I have a excel file that contain fallowing columns (in order from excel)
- Division
- Subdivision
- Team
- Location
- Name
- Employment Start Date
- Position (internal)
- Headcount
What I wanted to do is to extend the Logged By dimension with additional information. The idea was that “Name” from excel is equal to user in Logged By dimension. So based on Division, Subdivision, Team, I wanted to build levels of hierarchy that would look like this:
- Division ← from excel
- Subdivision ← from excel
- Team ← from excel
- User ← from Jira mapped based on Name field from excel
All other fields would be properties for user and Headcount column would be a measure