Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Count of Status

Hi All. I have a requirement to calculate the number of time a submission number has toggled between different teams for two scenarios.  Data below: I need to derive two columns based on the...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    Anonymous See attached, Table (24). Toggle Index totals to 5, that's the overall toggle. Toggle Index Team has four 1's for Prereview and one 1 for IRB Review. Is this what you are looking for?

     

Iryna_K's avatar
Iryna_K
Frequent Visitor
2 years ago

Try Time in State for Azure DevOps extension https://marketplace.visualstudio.com/items?itemName=SaaSJet.tis-azure .


Using it, you don't need to upload data to Power BI. Reports will be generated automatically based on your Queries. You can also export them to Excel.

Available reports:
- Time in State
- State Count
- Transition Count