Hi there. I’d like to know at what time of day a status is typically transitioned to - ideally in intervals of an hour. So, for example, if I wanted to know what proportion of our issues, let’s say over the last year, have been transitioned to “Waiting for support” during each hour of the day (e.g. 6-7pm, 7-8pm etc), would I be able to do this?
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