I am working on the GP Answering Business Questions using SQL with R.
I am working on visualising some of the data with SQL: countries on x axis and total sales on y axis.
There is a ‘residual’ category (Other), for all those countries that were only included once in the database.
I cannot make this Other category appear as the last one in the chart. Can someone help please?
My code is
ggplot(data = country_metrics, aes(x=reorder(country, -total_sales),
y = total_sales,