Analytics Cloud: Accumulation Calculation for Geo Map

[julian_runner]

Setup

table_view is my data source in Analytics Cloud. The corresponding Dimension is table_dim.

table_view = (
id PRIMARY KEY INTEGER,
name NVARCHAR(20),
price DECIMAL(4,2),
store_id INTEGER
)

table_dim = (
store_id INTEGER PRIMARY KEY,
loc ST_POINT(3857)
)

Question

I want to display every store_id in Geo Map with the size depending on how often the store_id appears in the table_view. How can I achieve this?

Best Regards,

Julian

[julian_runner · Accepted solution]

Somehow it works now...