We have a transition name Update Due date (from any status to itself) and when user click we are grabing some data and updating the due date history so we need to know how many times the Due date history field have been updated.
Was trying to use user defined calculated members wiht the below code but does not work.
(
[Measures].[Transitions to status issues count],
[Transition].[Update Due date]
)
Hi,
The transition mechanism is not applied for the date custom fields.
There is a workaround with a Javascript-calculated custom field. Please check this example from eazyBI documentation:
https://docs.eazybi.com/eazybi/data-import/data-from-jira/javascript-calculated-custom-fields/calculated-field-examples/due-date-changes-by-time
Kindly,
Janis, eazyBI support
Hello @janis.plume
Thank you for your response.
We are using the paragraph type field and not a date custom field. So not sure why its not working.
What i am looking herre is, the paragraph field will automatically update using the automation and new entry will be added into it, so i want to count how many entries are there and display that count.
Thank you
Hi,
Not all field types can be enabled with the change history import, so that could be a reason why suggested solution does not work.
Please send a ticket to our support email, we could check how this field type works and if there is a workaround.
Kindly,
Janis, eazyBI support