automatization? of colours in a graphic line map (subway)

[jadev]

Hi there, this might be a really dumb question but I'm trying to add colours into a line map. Inside our big query we have more than 24 billions of entries for shape_id and route_id that come from our historical dataset made of GTFS data (33). So when we add route_id to 'colour dimension' we end up with 19.000 or more colours. It's to complicated to handle in their own. One could think of making a separated table inside big query and save only the routes and colours you want to display but even tho we tried, we couldn't find a way of doing it faster. ¿Anyone knows a better way of handling this situation?

PD: Sorry for the bad English it isn't our first language.

[ArkadyZagdan]

@jadev 
Your problem is more complicated and you will face way muchh more limits than just number of available colors in the LS.
Maps have also their limits in terms of showing number of route_ids.
Consider rearranging your datasource first and using custom queries based on what exaclty you seek to achieve with the final report.

Here is an example of dashboard where you can limit your GEO points based onn city you want to show data for. 

https://lookerstudio.google.com/reporting/418a5e3e-1c67-466c-8b82-62a59a76ff7e/page/hPUyD

By passing parameter you can filter out unwanted data and make thhe chhart posiblle to render all needed IDS. But first you need to think how to logically group them color wise.