Point Map and a string dimension in color - leading to Errors?

Hi team,

I’ve a dashboard wherein basis the Lat/Long plus a dimension has been plotted on a point map and 3 data columns have a parameter linked to it.

It seems like there’s a running query that puts the dashboard on loop if we zoom in to areas and use the parameters across the 3 data columns together.

Would like to understand what’s the root cause of this?

We used the SQL editor to show all the queries when the above steps (zoom in to area and use parameters) were used and it shows these as a running query!

Attaching a link from Omnisci documentation which mentions about only the COUNT aggregation function is supported

HI @Shyam,

Can you explain what do you mean that “there’s a running query that puts the dashboard on loop if we zoom in to areas and use the parameters across the 3 data columns together.”

To know what is going on you can turn on the SQL console logging opening the dev-tool of your browser and running this command

window.SQLlogging(true)

image

then reload the page and you should see the queries that HeavyImmerse is running against the database and their runtime

I’m sorry but I cannot see any attach, could you re-upload?

Regards,
Candido