Category colors on torque

[المشرف العام]

I’m trying to create a torque viz on the CartoDB dashboard following this StackExchange post: Using different colors on Torque CartoDB

I followed that answer, but my marker colors are still all the same.

SQL and CartoCSS are below, and here is a link to the viz: https://pgrasmussen.cartodb.com/viz/c3b82e78-8f4f-11e3-8156-0e625a1c94a6/map

Any ideas?

SQL

SELECT *,CASE WHEN type='Theft' THEN 1WHEN type='Accident' THEN 3WHEN type='Vandalism' THEN 7END as type_numberFROM damage_nigeriaCartoCSS

/** torque visualization */Map {-torque-frame-count:512;-torque-animation-duration:30;-torque-time-attribute:"cartodb_id";-torque-aggregation-function:"count(cartodb_id)";-torque-resolution:2;-torque-data-aggregation:linear;}#damage_nigeria_viz{ comp-op: lighter; marker-opacity: 0.9; marker-line-color: #FFF; marker-line-width: 1.5; marker-line-opacity: 1; marker-type: ellipse; marker-width: 6; marker-fill: green;}#damage_nigeria_viz[frame-offset=1] { marker-width:8; marker-opacity:0.45; }#damage_nigeria_viz[frame-offset=2] { marker-width:10; marker-opacity:0.225; }#damage_nigeria_viz[value=3] { marker-fill: red; }#damage_nigeria_viz[value=7] { marker-fill: blue; }

أكثر...