Historical Data
Help

Please read through the following instructions to help you get the most from The Legal 500 Historical Data service. Note that complete historical data is available to download as a simple Excel spreadsheet from the home pages of each available edition.

FILTER OPTIONS

1) INITIAL FILTER

Historical Data views are supplied with filters to allow you to drill down to the exact data you need. The first filter to the top right of your data view is the Control Filter. Use the check boxes to determine which subsequent filters may be applied to the data view you have selected. NB that all adjustments to the data view will require the data to be reprocessed. Due to the amount of data involved, new visualisations can take a few moments to appear on screen.

2) SUBSEQUENT FILTERS

Depending on your initial selection from the Control Filter, various options will appear beneath to allow you to narrow your data search more precisely. Select from the checkboxes to create the visualisation you need.

3) ADDITIONAL FILTERS

Different data views feature various filter types to help you break up the data more effectively. Choosing combinations of these filters allows you to track rankings performance via different interpretations. In the example at right, a particular grouping of firms might be selected (using the “Firm Name” filter), over a chosen period of time (using the “Year” filter”), with a specific range of tier rankings (using the “Ranking” slide filter. The “Table Type” filter in this example has “Recommended fims” selected, meaning that only principally recommended firms are included in the resulting data visualisation.

4) FILTER FUNCTIONS

Additional options are available within text-based filters: hovering at the top right of the “Firm Name” filter in the example on the right reveals a magnifying glass. Clicking on this allows the user to search directly for a specific firm (rather than scrolling through large numbers of firms in the drop-down box).

Use the “All” check box on relevant filters to reset the data to include or exclude all items in the filter list. This can be easier than going through selecting or unselecting individual options from a previous selection.

Next to the magnifying glass search option is a small arrow. Click on this to toggle between multiple value or single value lists. This can either simplify your filtering options, restricting your view to individual selections rather than the entire available range; or vice versa. You can also toggle between excluding or including your selected values from your data view here.

VIEWING OPTIONS

1) ORDERING DATA

Once the data visualisation filtering is finalised, you can toggle the ordering of your data on screen (eg to run in reverse size order rather than largest number first) by clicking on the small graph icon at the bottom of the data view.

2) INTERACTIVE VIEWS

For more information from individual charts, hover over the relevant record to reveal the numbers behind the visualisation.

DOWNLOADING AND SHARING YOUR VISUALISATIONS

NB – The Legal 500 Historical Data is exclusively available for download to subscribing firms. As subscribing firms, you are free to utilise the data as you wish in your own internal and published materials. However, The Legal 500 rankings information remains copyrighted. 

For full details of our copyright policy please click here

1) DOWNLOADING DATA SETS

Once filtered and arranged as you want it, the data can be downloaded in several formats. Select from the following options to create the file you need:

  • Image – produces a .jpg rendering file of your visualisation
  • Data – exports the data set in text form, which can be downloaded to your computer as a .txt file
  • Crosstab – exports the data as a .csv, which can be opened in Excel to show the data in spreadsheet form
  • PDF – exports the visualisation as a .pdf file for ease of transfer.

2) SHARING YOUR DATA

The Legal 500 Historical Data visualisations can be shared by email, posted to Facebook, Twitter, embedded on your own website, or otherwise distributed as a weblink using the functions at the bottom left of the visualisation.

3) DOWNLOAD AS TABLEAU WORK SHEET

The Legal 500 Historical Data is powered by Tableau. Our data visualisations can be downloaded as Tableau work books. A free version of Tableau software is available for download here. You will need Tableau Public installed on your computer in order to open, edit and manipulate The Legal 500 Historical Data Tableau downloads.