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% |
LinkedIn
Twitter
