How to show hourly cost for person?

[kalos]

I would like to calculate the working hours on the basis of an hourly cost for each person. At the moment I am using a report where I take the hours worked by people from Tempo Timesheets but I do not know how to match the hourly cost to make the calculated hours appear in the columns. Can anyone help me ?

[gerda.grantina]

Hi @kalos ,
You can import additional data to import costs per “Logged by” user.
See the “Rates import for a user” in this community post:

How to build profit & loss report with additional data import

Overview In this example, JIRA has custom field Cost Center and a file with a budget for each Cost Center per month. Cost calculation goes over logged hours and user rate. Users have flat rates in a seperate file. The example describes how to import both files into eazyBI, mapping budget to custom field Cost Center and Time, and mapping Rate to Logged by User. You could either upload a file, import data via REST API, or SQL, or use Google Sheets in the same way. eazyBI supports additional data …

Or you can use the CASE WHEN statement. The formula for “Rate” would be this:

CASE [Logged by].CurrentHierarchyMember.Name 
WHEN "User 1" then 40
WHEN "User 2" then 50
ELSE 0
END

To get the total expenses, use this formula:

Sum(
  Filter(
    DescendantsSet(
      [Logged by].CurrentHierarchyMember, [Logged by].CurrentHierarchy.Levels("User")),
      [Measures].[Hours spent]>0
  ),
  [Measures].[Rate]*[Measures].[Hours spent]
)

best,
Gerda // support@eazybi.com