Need help in creating a calculated field in Google Data Studio in Pivot Data - Stack Overflow

admin管理员组

文章数量:1400674

I am working on Looker Studio. I am trying to plan for my new project and I have a table which has following fields Employee name, Date, Current Capacity(range of 0-1). I am accepting the user input on two things Effort per Item & Total number of items and multiplying this, I am calculating overall Effort required. I also have a date filter, which gives me the duration in which the project needs to be delivered. Calculating the available capacity sum and convertig it in hours, I fetch available hours and if the available hours are more than effort, I calculate new field 'Recommended Resource Capacity(RRC) which is

Calculated Effort Divided by Total Person Days Available(Count of employees when row exists between start and end date of project)

Now I want this RRC to be added to each row of the table because I want to see what would be their 'new resource capacity' i.e RRC + Current Capacity and if its more than 1, I don't want to proceed with that option.

My issue is I am not able to create a field that would allow me to do this since aggregration of metrices is not allowed while making calculated fields How to achieve this

本文标签： Need help in creating a calculated field in Google Data Studio in Pivot DataStack Overflow