I also have Belgium, Germany and Netherlands.
For Belgium :
'Belgium' as country,
[price] as BE_prices;
and the same structure for Germany and Netherlands (where BE is substituted by DE and NL). I also have a synthetic key issue with date and country but I'm not sure if it is related (and I still hope to manage to fix this by myself (even though any suggestion is warmly welcomed))
Follow these steps to
Create a spreadsheet with just 1 column.
Write country in the first row.
From the second row, write down the countries you wish to plot in the map.
- Save the spreadsheet and use data manager to import the file.
- Pepare the data
- Import the File
- Goto the app overview and open a sheet
- Create a map object and add a dimension. You will see country as a dimension to pick.
Your script will have sections managed by you (unlocked), and one managed by data manager (locked)