I am creating a test board via mondy.com for our testing within the organisation.
I need a column which counts the number of times the status changes.
Like , i have stages called Defect Identified, Retest , Defect Resolved etc. So i need to track how many times the retest status is hit by the tester. And would track the count in another column.
Is there a way to do that ?
Thanks
Merin
Hi @SnehaM - if you create a number column (lets call it Retest Count), you can use a custom automation like the following:
Where Status changes to Retest, increase Retest Count by 1
Hope this helps,
Mark
Thanks @mark.anley thanks and its working, hurrayy !
Hello @SnehaM ,
Another option for your case can be addressed with the Board Email Reports app. It will provide more detailed information on status changes over a period specified in the automation rule.
The app provides the following types of reports.
On a board/project level:
On an item/task level:
It aggregates the changes in the activity log by the column you choose and over the period you choose in the automation rule, and sends the xls-report to any people you mention in the rule (no guest access needed! ).
For you case you need status report. In the automation rule you specify include all the transitions between status states or only direct status transition (ex, directly from In Progress to Done). This is an example:
The email you get will contain the xls-report and roundup of changes over the period you mentioned in the automation rule:
This way, you can see not just how many times the status changed during a specific period, but also which changes happened
You can try out the app for free and check if it exactly meets your case.
