Hi,
Is there a way to query the name list of those who made changes to a ticket?
Hi @Jet
That is very tricky considering what changes eazyBI pull for tickets.
There is an issue update date, which represents the timestamp of the update of the ticket, but that field is not linked to users who made the change. It just shows when the ticket was updated the last time.
Also, if you keep the checkbox selected to import changes for tickets, eazyBI would create a Transition Author dimension that can be used to analyze transitions by authors using various transition-measures, but not all Jira fields can be analyzed using this dimension.
By default, you can get a list of users that made a change in following fields:
Issue Type, Status, Resolution, Sprint, Priority
Additionally, you can set up and import change historyfor single-value Jira custom fields when importing them as dimensions with value change history.
But that won’t help you analyze the changes in multi-value fields, such as Label, Fix version, Component. It is not possible to import change history for multi-value changes in eazyBI.
And that also depends on where you use eazyBI app for Jira - Atlassian Cloud or Atlassian Data Center. In Data Center case we use different APIs to pull history for tickets and then list of fields is shorter.
In case of Jira Cloud, you might explore account-specific calculated fields, that can let you pull additional data about each ticket from the changelog and generate list of users for the ticket that made any change (ever), but it won’t help you always to see - which fields they changed.
You can start by creating a new user-defined calculated measure using this formula:
It would let you see the list of users (CSV string) who made the changes for those fields that eazyBI is able to pull with history in the data cube.
Generate(
Filter(
DescendantsSet(
[Transition Author].CurrentMember,
[Transition Author].[User]
),
(
[Measures].[Transitions to]
+
[Measures].[Transitions from]
)>0
),
[Transition Author].CurrentHierarchyMember.name,
“,”
)
If that doesn’t help with your use case, I recommend reaching out to support@eazybi.com with more details.
Martins / eazyBI
