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