Click the pink "Options" menu and select "Add Pivot"

This will add a new pivot dropdown menu to the sentence bar, click "Please select" and you will be shown all the columns in your dataset.

You can either type to search for your column or scroll down to find it.

Either press enter or click the column you'd like to pivot by and you will be taken to a pivot chart.