Can someone help with the formula i should used for a calculated field in google/looker studio.
I have a dataset of employees who have completed their timesheet and I need to create a new field showing the ‘%’ billable time for each employee and add in the formula for the calculation, but not sure how to do this.
I need to show billable time as a % of each employee (or the team’s) time, rather than as a % of the total. So for example if John had 154.7hrs billable and 7.9hrs non-billable, then his total time is 162.6hrs and his % billable time would be 154.7/162.6 = 95.1%.
Any help would be appreciated on how to create this formula in the calculated field.A sample of the dataset is shown here.
Tried calculating the % in looker studio, but that gives me the % of each employee using the % of the total time in the column, without specifically looking at the total time per employee and the billable times.
Ray is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
2