for example: I have various issue types, one is called “L3 Support” and another is “Escalation to RandD” … and they change constantly but I need to measure and count how long (in days) an issue has been in various “types”…(similar to 99.9% of the info out here having to do with counting how long issues are in various status’ and when they transition)… but there is nothing to help out with “type”… for example: if an issue was created on Nov 2 as an “L3 Support” type and then changed 4 days later to an “Escalation to RandD”… i need to create a report that says issue abc-123 spent 4 days as an “L3 support” type and then 5 days or whatever days as an “Escalation to RandD”… I have spent >70 hours trying to figure this out… I need the calculated measure code, the rows and columns, etc… please help!!!
also… if you could, indicate what should be literally typed and what is depending on my specific local naming convention of specific condition… like when if you send someone code, they indicate substitute your own name for the text in green or in brackets, etc… thanks
Out of the box, there is no such measure to get time spent in each issue type. You may try to build custom calculation and count the time between two dates based on measures Transition to first timestamp and Transition from last timestamp, but this won’t be accurate if an issue can get the same issue type twice and might be a quite heavy calculation.
Then go to import options and select custom field “Days for Issue Type” for data import as measure and as property.
After data import, a new measure Days for Issue Type (Measures -> Select member -> Custom field) will be available for your reports. Use it with Issue Type dimension in the report.
Zane / support@eazyBI.com
Thank you so much for this and the previous replies from you… I was out of work for a few weeks for various reasons but now getting back and I will review your feedback in detail and let you know results… - Ed