Forum Discussion
Average Time in Each State
I have Data which shows Created date, Change Date and Progress Time(Custom Added column giving difference of Change and created) along with State and Category.
I want to visually represent Average time under each state giving filter to Category. Basically my visual should answer. How much is the average time to convert a workitem to Development for each category .
| ID | Category | Created Date | Change Date | ProgressTime | State |
| 1234 | A | 1/1/2020 | 10/1/2020 | 10 days | Development |
| 5678 | B | 2/1/2020 | 13/1/2020 | 11 days | Prod |
| 9112 | C | 5 | New | ||
| 1314 | D | 7 | Prod | ||
| 3566 | A | 3 | Development | ||
| 9826 | A | 8 | Production | ||
| 9864 | C | 1 | Development | ||
| 0981 | B | 0 | New | ||
| 7860 | C | 10 | Development |
What is the right visual to represent Progress over time and if we have a target of converting a workitem in 1 day it can tell how ahead or behind are we from target . Need to understand which visual can help showcase the picture efficiently
1 Reply
Hi GunjanKathuria ,
In this case believe that the option can be clustered column chart:
This also depends on the way you have your story telling.
