How to calculate cost of linked issues?

Questions & Answers
2

I will use some assumptions to describe one scenario how to calculate costs.
I assume you are using Logged by dimension for counting Hours spent for Departments by listing set of users in each of them.

I assume you have a Rate for each user. Here is one tip how to import rate for Logged by user. Check the part with user Rate import in the article.

Here is an example fomula how to calculate costs using Logged by imported property Rate by particular group of users, including time spent on linked issues. This is example for Story issues with linked Bugs, imported as property.

SUM(Filter(
Descendants([Logged by].CurrentMember, [Logged by].[User]),
CoalesceEmpty(
  [Logged by].Currentmember.Get("Groups"), "")
  MATCHES ".*groupname.*"),
  ([Measures].[Hours spent]
  +
  SUM(
    [Issue].GetLinkedMembers('Bugs'),
    DefaultContext((
      [Measures].[Hours spent],
      [Issue].CurrentMember,
      [Time].CurrentHierarchyMember,
      [Logged by].CurrentMember))
  )) * [Logged by].CurrentMember.Get('Rate')
)

The formula works on Issue level for Story issues only.

Please send more details, including current report definition to support@eazybi.com for more precize answer.

Daina / support@eazybi.com