Capture the last history log in a custom field

zane.baranovska · May 13, 2021, 8:00am

You can get the date of the last transition for the single select custom field also without JavaScript.

Import change history of the custom field in eazyBI.
1.1 In advanced setting add parameters separate_table = true and changes = true to enable changes for import options. Here are more details and example: Advanced settings for custom fields
1.2 In import options, in the custom field tab, select to Import value changes and import data.
In the report, create a new calculated measure in Measures that would show the timestamp of the last changes in a specified field. For the calculation use hidden measure “Transition to/from last timestamp” and hidden dimension “Tranistion field”. The expression might look like this:
```
TimestampToDate(
  ([Measures].[Transition from last timestamp],
  [Transition Field].[custom field name],
  [Time].CurrentHierarchy.DefaultMember)
) 
```
There are more details on hidden historical measures and dimensions: Import issue change history.

You can check out other Community topics on similar use cases to analyze custom field history: