Get author, datetime of customfield changeHistory

Questions & Answers
1

Hello,
I was able to get to report all the values customfield has had (Q1,2,3 are values)
image

using this
https://docs.eazybi.com/eazybi/data-import/data-from-jira/import-issue-change-history#Importissuechangehistory-Customfieldchangehistory

Is it possible to get to report:

  • author, who set new value
  • datetime of this event
2

Hi @cybertachikoma,

You are already halfway there. With the change history import enabled for the custom field dimension, you can use it with historic measures - Import issue change history. I recommend defining two calculated measures to cover both your requirements. The first one will return the issues in which users changed the custom field value. Add the Transition Author dimension to see who performed the changes. See an example with the formula below:

([Measures].[Transitions to],
[Transition Field].[T-shirt size])

In my example, the field is “T-shirt size”. Update the formula to consider your field. Next, to see the last date the particular author made the change, define a new calculated measure:

TimestampToDate((
  [Measures].[Transition to last timestamp],
  [Transition Field].[T-shirt size]
))

I recommend drilling the first measure into the particular custom field dimension. See more details about that functionality here - Create reports. See the resulting report below.

Screenshot 2023-02-16 at 13.19.19
Screenshot 2023-02-16 at 13.19.192038×1774 352 KB

Please look at our documentation page for more information on defining calculated measures - Calculated measures and members.

Best,​​​
Roberts // support@eazybi.com

3

Hi,
I’ve created config for cf “User_Priority”

[jira.customfield_12406]
data_type = "integer"
dimension = true
changes = true

and imported it for particular Issue
image

Here’s the result
image

And now I have 2 questions:
1.
I’ve used Time dimension, because without it I could not get the range of records. It looked like this
image

If I undestand you right - I need to get records in dimension. How can I do it?

Duplicated rows by Number show some records in issue History that are not about changing cf “User_Priority”
for example - the only record in 23.12.22 was

image
image730×77 4.05 KB

How to get the necessary records?

4

Hi @cybertachikoma,

It seems you use the historical measure instead of the suggested calculated measures. Also, the report structure is different from the recommended one.

Please try to retrace the steps suggested in my previous post and replace the dimension name “T-shirt size” with yours - “User_Priority”. Use the User_Priority dimension in the report columns and Transition Author in rows. Then define the calculated measures and select them.

So the formula for the last date when the field value was changed could look similar to the one below:

TimestampToDate((
  [Measures].[Transition to last timestamp],
  [Transition Field].[User_Priority]
))

And the number of transitions made by each user from Transition Author is similar to the one below:

(
  [Measures].[Transitions to],
  [Transition Field].[User_Priority]
)

In the current structure, the measure “User_Priority history” returns the sum of the field value changes for all Time dimension members. So the number 910 on Dec 23 2022 means there were issues with the total sum of 910 at the end of that particular date. It doesn’t mean the changes occurred in the specific field. Try the suggestions above for changes in the field made by certain users.

Best,​​​
Roberts // support@eazybi.com