Chloropleth Map of Number of Applications by US State

0 Answers 12 Views
General Discussions
Logan
Top achievements
Rank 1
Logan asked on 26 Jan 2022, 07:25 PM
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?
Neli
Telerik team
commented on 31 Jan 2022, 09:15 AM

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.

Logan
Top achievements
Rank 1
commented on 31 Jan 2022, 03:37 PM

I was able to import a shape file of the united states into the choropleth wizard. The choropleth seems to be the visual that I want to use.  My problem seems to be when I want to count the occurrences of each state I am trying to determine the expression to do so. For example, when I make a bar chart using state field as the category and count state as the value I get the desired output. However, in the choropleth, I want that count field to be the coloring factor, but count state doesn't produce the same results. The count for each state comes out as 1 and there's nothing to distinguish the color data field interval
Logan
Top achievements
Rank 1
commented on 31 Jan 2022, 04:34 PM

The color data field is working for the order of the states. I had to manipulate the data a lot to get the states ranked in order of count from largest to smallest and I got this
Logan
Top achievements
Rank 1
commented on 31 Jan 2022, 05:46 PM

I'm attaching my report and sample data
Logan
Top achievements
Rank 1
commented on 31 Jan 2022, 05:46 PM

I'm attaching my report and sample data
Neli
Telerik team
commented on 14 Feb 2022, 04:06 PM

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.

No answers yet. Maybe you can help?

Tags
General Discussions
Asked by
Logan
Top achievements
Rank 1
Share this question
or