Is there a way to have a start and end date in a Carto timeline (instead of the usual start OR end date?
I don't have any programming experience.
Torque works aggregating your data in bins according to a specific date/timestamp column. However, you have two. So, in order to get the animated map you are looking for, you have to restructure your table.
I suggest duplicating (unnesting) each row in two so you will have the same point/register twice with two different dates (start and end) but same id (category). Now you will be able to make a Torque Category map.