Using a directed network diagram, we were able to identify the nations that experienced a spike or dip in their imports from other nations in 2010. We also noticed the nations that imported the most in that visualization. How about we now ask the question: which country exported more than they imported in 2014? How much did they import or export? Let's say we already have a list of nations in which we are interested, and they happen to be China, Germany, India, Japan, the United Kingdom, and the United States.
We will use a chord diagram to do this. The filter conditions on the year 2014 and the list of trading nations in which we are interested can be specified in the Custom WHERE clause text field:
(exporter="United Kingdom" OR exporter="Japan" OR exporter="China" OR exporter="Germany" OR exporter="India"...