Can you please help me with mdx measure

Questions & Answers
1

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.

2

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
3

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

image
image884×574 30.5 KB

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

Please help me with the appropriate measure.