Using the cwurData table, create a cross-tab showing the number of Publications per Country broken down by Institution, and filtered by Country to only show United Kingdown (UK). For the University of Manchester, what percent of the total publications were contributed in 2014?
Phew! Tricky one for sure. This question tests multiple concepts and will help you revise them. We'll be using filters, as well as quick table calculations(percent of total) for this one.
1) Firstly, let's dragCountryandInstitutionto the Rows shelf, and year (discrete) to the Columns shelf. Then, dragPublicationsto the Text Icon in the Marks Shelf. The following is our view:
Currently there are no comments in this discussion, be the first to comment!