Hi @SamDean,
To import the hour of a specific transition as a dimension, you require a JavaScript calculated custom field. Unfortunately, I don’t have such an example by hand. But you can try to retrieve the transition date with the “Cycle date” example from our documentation page - JavaScript calculated custom fields. Specify only the one status in the cycleStatuses variable of the JavaScript code.
Next, try altering the JavaScript code and retrieve the hour of the transition instead of the whole date. The “Hour of day created” example could help you with that Issues created out of office hours.
Then you could change the data type of the JavaScript calculated custom field to integer and enable the dimension import with dimension = true.
Best,
Roberts // support@eazybi.com