Need to find settings in Map Layer

Hello

I am trying to follow the tutorial on GitHub - FIWARE/tutorials.Time-Series-Data: πŸ“˜ FIWARE 304: Querying Time Series Data (QuantumLeap) . I am stuck at the point that says:
"Click on Visualizations tab on the left and set as follows:

  • Map Layers:
    • Lamp:
    • Icon: lightbulb-o
    • ClusterType: average
    • ColorType: fix
    • Column for value: value
    • Maker color: red

I can’t find these settings because I guess the document was created with an older version of Grafana.

Thank you in advance

Sakis

Welcome @xanthi

What is your datasource? Createdb or something else?

Can you post some sample data text here?

Hello and thanks for the quick reply!

The data source is CrateDB. Sample data you can find on this link:
https://github.com/FIWARE/tutorials.Time-Series-Data/blob/master/import-data

Regards

Sakis

1 Like

I would use infinity plugin with UQL and jsonata to extract the data and map it

https://try.jsonata.org/A0mwsHPkn

but since you will probably query the cratedb database you should use Orchestra City plugin

with das_pretzels as (
 select unnest(store_details['entities'] ) as obj 
   from berliner
)
select obj['name']['value'] as name
,obj['location']['value']['coordinates'][1] as lon
,obj['location']['value']['coordinates'][2] as lat
from das_pretzels;

Well, I managed to show the spots on the map with the Orchestra City plugin. So thanks a lot for your help!

1 Like