I am trying to create a heat map, colored by the number of applications received from each US state. My CSV hundreds of applications, each containing a specific state origin defined at Fields.State. When in the chloropleth wizard I want to use the number of occurences from each state as the color data field so I use count(Fields.State). However, it is counting each field uniquely and designating it with a value of one. What expression can I use to correctly count the number of occurrences of each state to use as the color data field?
Hi Logan,
I suggest to generate the map as an image via third party libraries and then use it in reports via PictureBox item. I'm afraid the Heat maps are not supported.
We have already a request for a heat map in our feedback portal - heat map. You can give a vote for this request. New features are selected for development based on the demand from our community.
Let us know if you need any additional information.
Hi Logan,
Thank you for the provided report. I inspected it but it seems that I will need also the shapefile of the map.
Note that you can use the Exec(scope, expression) data function in order to execute the sum in a given group.