Jump to content

Recommended Posts

Isn't that what the included task attribute 'worked hours' or 'worked days' (depending on your settings I believe) does? I believe it just calls {self.worked} in an attribute.

 

EDIT: sorry I just re-read your question and realised you're asking for a sum of tasks on the shot... Very good question. I can't find anything about accessing children attributes on in the docs. It would however be most useful.

Link to post
Share on other sites
3 hours ago, tokejepsen said:

Wanted to accumulate all worked days on tasks on a shot, together and show as an attribute on the shot.

Does anyone already have an expression for this?

Unfortunately it is not possible to do this. The expressions can only pull data from the attributes on the same entity.

A possible solution is to setup an event listener and calculate this manually. There are however limitations to this and if I recall correctly there is no event or not enough information on an event if a timelog gets deleted to figure out the "parent" task to update this summary.

Link to post
Share on other sites
Quote

A possible solution is to setup an event listener and calculate this manually. There are however limitations to this and if I recall correctly there is no event or not enough information on an event if a timelog gets deleted to figure out the "parent" task to update this summary.

I guess if we are looking at such solutions, I could also just make an action to calculate it on-demand.

 

Is there nothing in the "Reports", where we can see a hierarchical breakdown of the worked days? Would be great to go down the project hierarchy and explore where the time has gone.

Link to post
Share on other sites
13 hours ago, tokejepsen said:

I guess if we are looking at such solutions, I could also just make an action to calculate it on-demand.

Yes, definitely - having a custom attribute where you summarise based on events would perhaps be an option if you absolutely must have it in the Spreadsheet.

13 hours ago, tokejepsen said:

Is there nothing in the "Reports", where we can see a hierarchical breakdown of the worked days? Would be great to go down the project hierarchy and explore where the time has gone.

Not at that level, you can have breakdowns based on Project, User and Task types but not hierarchically. The closest you get is the summary in the Spreadsheets, but that only work as long as the Project contains less than 500 tasks. Above 500 tasks the Spreadsheet starts to lazy load data and since the summary is made "client side" they will appear empty until expanded.

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...