I want to create a report to compare the field value of an issue at a specific date vs now, can you please help me on building this report

Questions & Answers
1

Can you please help me with the mdx measure to get the values of a field in the report.

I have followed the below document and able to import issue history for a field.

Showing change history of custom field values (imported as property & dimension) - Questions & Answers - eazyBI Community

2

Hello @Amzad

If you have imported issue history for the particular field, you could try fromula below to find the value at a specific date. In the example below please replace “CF FIELD NAME” with the name of your custom field. And Replace “May 31 2023” with the specific date at which you would like to find the value of the field. To get the current value of the field, select the issue property “Issue CF FIELD NAME” from the Measures dimension.

Filter(
   [CF FIELD NAME].[CF FIELD NAME].Members,
   DefaultContext(
      (
         [Measures].[Issues history],
         [Time].[Day].DateMember("May 31 2023"),
         [Issue].CurrentHierarchyMember,
         [CF FIELD NAME].CurrentHierarchyMember
      )
   ) > 0
).Item(0).GetCaption

Best wishes,

Elita from support@eazybi.com

1 Like
3

Thanks for the above I will