Tempo remaning multiply by Assignee cost as a function of time


I use the “assignee” field to determine who assigned the Tempo remaning, to associate a cost with it.
I imported a csv file which gives me the cost of each JIRA user, and I would like to multiply it by the remaning to a date. In order to see in a graph the evolution of the cost by date

And I would like to be able to determine for all the dates, to whom the ticket is assigned, but I cannot find a way to do it.

In the event that there is a ticket that has been assigned to several people, I would take the first one on the list.

Date 1 Assignee on this date cost x remaning on this date
Date 2 Assignee on this date cost x remaning on this date
Date 3 …

For the remaning I use the Remaining estimated hours history, but I can’t get the assignee by date

Thank you for your help, I may not have been very clear.

Hi @adrienG,
Welcome to the eazyBI community! :wave:

To get costs per Assignee, you need to use the Assignee dimension in Columns and then you can use the Remaining estimated history and multiply it by assignee costs.

[Measures].[Remaining estimated hours history] * [Assignee].CurrentHierarchyMember.get('Costs')

In the report:

Gerda // support@eazyBI.com