Need Automation solution for below example?

[Sabarish]

Status and Effort at Feature Level
Feature	Status	Hours
Feature 1	To Do	40
Feature 2	Done	30
Feature 3	In Progress	60
Feature 4	Done	80
Feature 5	Done	40
Feature 6	In Progress	50
		300

Following should be the result of the automation: -

Summary at Epic Level
Status	Total Hours	%
To Do	40	13%
In Progress	110	37%
Done	150	50%

[Y Dang_Candylio]

Hi @Sabarish 

I think you could use the Dashboards instead. There's a gadget which is called Pie Chart. 

In this gadget, you can configure the filter which query the Epic and choose to show the status by percentage. It will be updated automatically by the real time.I hope this helps! 

[Sabarish]

Thank you, yes this would surely help. Also need to update the story estimates to the epic through automation. whenever new story is created or completed it to auto update estimates in epic level.

[Y Dang_Candylio]

Hi @Sabarish 

You can create an automation rule like this. Whenever an issue transition to Done, it will check the Epic of this issue. If the Epic is To Do or In Progress, it will be automatically transitioned to Done. 

Hope this helps!