Can you please help me with mdx measure

I want to build a report to see value change history of a custom field,
If FIT is a custom field, and XXXX and YYYY are values in the custom field, I want to show old value and new value of the field.

In rows I want to show issue key, and in columns I want to show summary, old value, and new value of an issue and when the value has been changed to the issue.

Is this achievable in eazybi?
If so can you please help me with the measures to get old value and new value of an custom field.

Hello @Amzad
‚Äč
‚ÄčThanks for posting your question!
‚ÄčTo be able to display custom field history, you should import the field history. Documentation here explains how to import Custom-field change history - Import issue change history
‚Äč
‚ÄčOnce you have imported the change history, please proceed with defining a new calculated measure with the formula below. This will return the previous value of your custom field FIT.
‚Äč

‚ÄčCASE WHEN
(
  [Measures].[Transitions from],
  [Transition Field].[FIT]
)>0
THEN
Order(
  Filter(
    Descendants([FIT].CurrentHierarchyMember,[FIT].[FIT]),
    (
    [Measures].[Transitions from],
    [Transition Field].[FIT]
    )>0
  ),
  (
    [Measures].[Transition from first timestamp],
    [Transition Field].[FIT]
  ),
  BDESC
).item(0).key
END

‚Äč
‚ÄčTo display the current field FIT value, select the issue property from Measures dimension ‚ÄúIssue FIT‚ÄĚ
‚Äč
‚ÄčTo display the time when the change happened, please define a new calculated measure with the formula below and select date formatting before saving the formula:
‚Äč

‚ÄčTimestampToDate((
  [Measures].[Transition from last timestamp],
  [Transition Field].[FIT]
))

Best wishes,

Elita from support@eazybi.com

1 Like

Thanks for the I will check on this and update on this.

Can you please provide me the mdx measure for where I want to get the issues in the passed status with due date less than today

I am trying to use the above measure, but getting the error.

Please help me with the appropriate measure.