I am trying to create a question with a grid map to add to my dashboard. The thing is that I need that question to be filtered by field filters from the dashboard. This grid map needs to count hired candidates by 1° latitude and 1° longitude
I created the grid map by first creating a query with the maximum granularity (each line a candidate with it's latitude and longitude) (using the native query option) and then I created a summarized table based on this first query, that counts the distinct values of candidates by latitude and longitude (using the Question option and selecting the first query):
I tried editing this new summarized query in the "view Sql" option and afterwards converting the question into SQL. Then I added the field filters there. It seemed to work but my latitude and longitude break when I do this. And they stop being ranges of 1°.
Is there any way to do this?
Thanks!