Average Time in Each State

[GunjanKathuria]

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

[MFelix]

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.