GYANA

GLOSSARY: Why do approval ratings rise in times of crisis?

Deepak Shakya

3 min • 12 May, 2020

To complement our report on rising approval ratings in times of crisis, we've highlighted all the steps you need to take to recreate the data visualizations in just a few clicks.

1. Donald Trump approval ratings

  • Connect to dataset ‘Approval Data’
  • In the table , switch on filters such that President is equal to Trump, and that Opinion is equal to Approve
  • Select the Scatter chart type
  • Place DATETIME on the x-axis, AVERAGE(Percentage) on the y-axis and Opinion as the Color

2. John F. Kennedy Approval Ratings

  • Connect to dataset ‘Approval Data’
  • In the table , switch on filters such that President is equal to Kennedy
  • Select the Line chart type
  • Place DATETIME on the x-axis, AVERAGE(Percentage) on the y-axis and Opinion as the Color

3. Tony Blair Approval Ratings

  • Connect to the dataset ‘Tony Blair Approval Data’
  • Create a new column, name this column DATE and insert the formula: PARSEDATE([Date], “%m/%Y”)
  • Select the Scatter chart type
  • Place Date on the x-axis, Net Approval on the y-axis and Status as the Color

4. George W. Bush & Barack Obama Approval Ratings

  • Connect to the dataset ‘Crisis Approval Data’
  • Create a new column, name this column DATETIME and insert the formula: PARSEDATE([Date], “%m/%d/%Y”)
  • In the table , switch on filters so that Year is less than 2017, Year is greater than 2000, Opinion is equal to Approve and President is NOT equal to Clinton
  • Select the Scatter chart type
  • Place DATETIME on the x-axis, AVERAGE(Percentage) on the y-axis and Crisis? as the Color

5. Joe Biden Tweet Sentiment over Time

  • Connect to dataset ‘Joe Biden Twitter Data’
  • Create a new column, name this column Sentiment and insert the formula: SENTIMENT([Tweet])
  • Select the Bar chart type
  • Place MONTH(Timestamp) on the x-axis, AVERAGE(Sentiment) on the y-axis and MONTHNAME(Timestamp) as the Color

6. Joe Biden Tweet Sentiment and Retweets

  • Connect to dataset ‘Joe Biden Twitter Data’
  • Create a new column, name this column Sentiment and insert the formula: SENTIMENT([Tweet])
  • Select the Scatter chart type
  • Place Sentiment on the x-axis, Retweets on the y-axis and MONTHNAME(Timestamp) as the Color

7. World Leader Approval Comparison

  • Connect to the dataset ‘World Leader Comparison Data’
  • Select the Bar chart type
  • Place Leader on the x-axis, Percentage Approval on the y-axis and State as the Color