Forum Discussion
calculating historical data for jira
Hello everyone, I'm trying to calculate the number of unresolved tickets (where the column status has no entry, so the status isn't closed, resolved or anything else) for every given Monday in my...
sure thing, thank you for taking your time.
first, here is a screeshot of my Histories table, where i calculated the IsUnresolved column:
next, my issues table, relevant columns highlighted:
and last, the visual with the mondays and UnresolvedTicketCount_ columns:
please let me know if you need anything more, best regards!