Show history of changes for customfield date field in time report

[Emiliano_Romero]

Hi, I have a custom field called “Fecha de Implementación” that can change value over time. I need to be able to graph the values ​​that the field had in a time report.
For example
first value = 2024/05/01
second value = 2024/06/04
third value = 2024/07/20

According to the values ​​of the field that the example issue had in a time report, it should count “1” in the months of May, June and July.

Thanks!

[zane.baranovska]

Hi @Emiliano_Romero,

In this case, you should create a new JavaScript calcauted field that would fetch the “Fecha de Implementación” field changes and import it as a new measure showing on which dates those changes happened.
Here are more details calcauted fields: Account specific calculated fields.

Please see this community post for the solution example:

How to show change history of a date field, but ONLY show the issues that have changed in the past month

Hi @Brian_Jones1, You might want to use a slightly different JavaScript calculated custom field that woudl indicate issues with the changed date field and when those changes were done. You might want to create a numeric custom field like “XXX date changed” that woudl count changes in the date field, and used together with the Time dimension would show on which date the changes were made. Using this setup, you can filter data with “Time” dimension. The report might look like in the picture bel…

Best,
Zane / support@eazyBI.com