Symbology based on Frequency With query layer

Question

I have a dynamic query layer (polygon) derived from feature class and SQL table.
 Attribute look like:

ID

City

1

city1

2

city1

3

city1

4

city2

5

city2

6

city3

7

city4

8

city1

9

city4

10

city5

11

city2

I need to write code that reports the total count for each value and create graduated color based on the count Using Arcade or any other work around in ArcGIS Online webmap, or ArcGIS Pro.

I know that graduate color could be accomplished only with Number field,

XanderBakker · Answer

Hi @ArmstKP ,

I am not sure, so I can't confirm, but based on what you are seeing I can imagine that there are restrictions with this datasource.

ArmstKP · Answer

@XanderBakker Is it possible to use Arcade to symbolize a view created in SQL Server?

When I bring in the view and click the symbology icon, I don't get the option to create an expression...

HushamMohamed · Answer

Hi Xander Bakker,

Unfortunately  this functionality is not available in the symbology profile as well as other functionalities.

I ended up re writing the SQL query  to include count field.

Thank you, for your Help.