I'm using Looker Studio and needing to build a report that shows the Users, The status of their projects, The count of each status for the User and the % of the status for the user.
I have the following data:
User | Status |
John Doe | Declined |
Jane Doe | In Progress |
Jane Doe | In Progress |
Jane Doe | In Progress |
Jane Doe | In Progress |
Jane Doe | Not Started |
Jane Doe | Not Started |
Jane Doe | Not Started |
Jane Doe | Not Started |
Jane Doe | Not Started |
Jane Doe | Not Started |
Jane Doe | Not Started |
Jane Doe | Not Started |
Jane Doe | Not Started |
Jane Doe | Not Started |
Jane Doe | Completed |
Jane Doe | Completed |
Jane Doe | Completed |
Jane Doe | Completed |
John Doe | Initiated |
John Doe | In Progress |
John Doe | Initiated |
John Doe | Initiated |
John Doe | In Progress |
John Doe | Initiated |
John Doe | In Progress |
I need to create a report like this but running into issues in how to properly build the formula or getting this to work in the Looker Studio Pivot Table:
User | Status | Count of Status | Percent of Status |
Jane Doe | Completed | 4 | 22% |
Jane Doe | In Progress | 4 | 22% |
Jane Doe | Not Started | 10 | 56% |
John Doe | Declined | 1 | 13% |
John Doe | In Progress | 3 | 38% |
John Doe | Initiated | 4 | 50% |
I see. It looks like you're trying to get the percents as subtotals. That is, all of Jane Doe's rows should add up to 100%, but the total of all the rows will be 100% times the number of users. I don't think that's possible to build with formulas in Looker Studio. I think that logic would need to be defined in your data source.