Handshake only filters and supports 'OR' logic when filtering on multiple dimensions within a single field in the Analytics tool. However, you can build your own calculations if you need to add 'AND' filtering to your report!
Set up an 'AND' calculation
In order to utilize 'AND' logic, you will need to set up a calculation within the Analytics report.
To experience the steps, open this example report that uses a calculation on two unique institution labels. Please note that unless you have these particular labels at your institution, you probably won't see any results. We'll just use this as an example to work from!
On the example report, notice this Calculations section is highlighted:
Click the Calculations box, which will open a Table Calculations dialogue:
We filtered specifically for 2 particular labels - "fall 2017 graduate" and "work study eligible". The way this calculation is setup, if a student has both of those labels, it will return a "yes" in this column on our report:
Here is an example of the syntax that we used:
if(contains(${added_institution_labels_on_students.name_list},"fall 2017 graduate")AND(contains(${added_institution_labels_on_students.name_list},"work study eligible")),yes,no)
You can use this as a template for any labels that you need 'AND' filtering for, and you can also build any other calculations you need! For more information on these table calculations, explore this Looker documentation.
If you wish, you can exclude any 'No' rows from the visualization, which will mean filtering the data within Excel post-download won't be required. To do so, click the gear icon from the calculation field, then click Hide "No's" from Visualization:
We'd also love for you to share any tips in our Handshake Community. This is a place for you and your team to connect with other career centers to share best practices and learn from each other on how to make the most out of Handshake!