Structure.Gantt | Resource usage calculation

[Manali Butey]

I am having a play with time tracking and using it for work estimates. so far so good apart from the fact that if a task records remaining time estimate as 0h i.e. task is done , in the resourcing pane i can see that the hours are still being counted.

When i checked my config and i turned on set task as milestone when duration / estimate is set to ) the hour calculation in resource pane seems to work fine.

My question is can I have tasks that have remaining time 0h show as task bars in gantt and have resource pane not take into account the hours as they are zero ?

TIA

[David Niro · Accepted solution]

Hello Manali

David from ALM Works here!

The easiest way to ensure that issues with 0 remaining estimate do not show against your resource allocation is, as you mentioned, treat issues with 0 duration as milestones.

However, I understand that this is not ideal in your scenario. So, one other way to do this would be to use a formula to define your resource attribute.

You can set this in the Resources section of your Gantt Configuration .

For resource assignment attribute, you will want to select Formula from the dropdown list and define your specific criteria.

Here is an example of something that would get you started:

 If(remainingestimate > 0,assignee)

In this example, if my remaining estimate is greater than 0, the task will be using the Assignee as my resource and nothing when it is 0.

You will need to adjust this to match the nuances of your use case. 

I hope this helps!

Best Regards,
David Niro
www.almworks.com

[Manali Butey]

Hi @David Niro 

I tried your suggestion and it worked as expected. Thanks

Follow up question - My resource attribute formula is If(remainingestimate > 0 and MATCH(summary;"Workshop - *"), resources,remainingestimate > 0,assignee)

resources -> custom field (multi-user)

This is working fine, however :

1. I can see in my resource pane that I get groups with saying JIRAUSER40xxx,JIRAUSER4xxx where the resource field is applicable. Instead can the hours be added to the users totals  i.e. have seprate row each for JIRAUSER40xxx and JIRA USER4xxx ?
   
2. When the resource field is applicable is the default resource unit considered as 1 if set as 1

[David Niro]

Hello Manali,

I am glad to hear that it worked for you.

Regarding 1, that will not be possible as far as I am aware.

Regarding 2, if your default resource setting is listed as 1, then yes.  However, you can change each resource's allocation by adjusting the Resource Settings.

I hope this helps.

Best Regards,
David Niro
www.almworks.com

[Manali Butey]

okay, we will create multiple tickets to workaround this. 
Ability to individually adjust the unit is great, thanks for pointing that out.

• Could I export the resource usage in excel ? 
• Could i use the resource usage data to to feed into Confluence ?

Thanks
Manali