Hi Looker experts, I’m looking to create a dashboard for diversity analysis of an org.’s hiring practice. The dashboard should dissect a group of people on 2 dimensions:
- diversity criteria (e.g. gender, race, ethnicity)
- the stages in the hiring process (e.g. shortlisting, interview, selected, job offered
While the second dimension (stages) will remain static, the user should be able to toggle the first dimension - view the dissection across stages by gender first, then toggle to viewing by race etc.
I could mock this up in Excel as shown in the pic. The diversity criteria is the filter to the overall graph, so users can toggle that attribute.
Would like to understand how I can create something similar in Looker.
(I have shared a snapshot of the data model that I used to get the chart in Excel as well.)