I want to make a list with all countries, and I want the list to change depending on the variable total_deaths_per_million for every date.
I realise my expression is far off. My first problem is that I can't work out how I get the right variable. With the expression I've tried I get the error message "Couldn't turn result into numeric value".
First of all, is it even possible to create an expression that works like I want it to? Anyone have any good advices?
Now I have two new questions;
Is there some way to change this data each second with an expression? So like first second shows 1st of january, and second 15 shows 15th of january? I've been trying this with multiple "if" statements, but it is alot of work to do it by hand.
And if so, is it then possible to make the countries change place smoothly? Whit this expression they just pop up at a different place, but I want the change of position to be visible. So that when one country gets a higher value you can see it move up along the list.
Ok, I thought you had a client because you mentioned you now have to use another dataset.
Anyway; is it going to stay a list of text and numbers , or are there going to be graphs, color-coding,... maps,...
best to plan a bit ahead and design a mock-up of what you want before trying to make it data-driven.
Filip has a good point here - prior planning is needed, in order to make it happen in a more clear way, with less friction and back and forth. Yet solely on my previous experiences in this field of data-driven animations, making them comparable through expressions is an overkill - too slow, too limited. While it has benefits of instant data updates when updating the file - its not beneficial enough IMO.
Nor it provides enough flexibility and easiness of customisation. My vote would be to go scripting instead, but of course - learning how to achieve similar through expressions is a good path to familiarise with expressions world!