ArcGIS Dashboard Arcade Expression for Serial Chart

Question

I am trying to create a Serial Chart from my webmap and apparently, I am unable to even start on the basics.

var portal = Portal('https://www.arcgis.com/');
var fs = FeatureSetByPortalItem(
portal,
'30d14060daaf4b298ef11a1101beb4a3',
0,
[
'Select a Project Unit',
'Select a Region',
'polygon_hectares'
],
false
);

The above-mentioned are the three fields of interest, I would like to create a serial chart with the "Select a Project Unit' field as the category field and Split by field 'Select a Region' and the statistic I would like to use as the sum for 'polygon_hectares/10000' field since it was recorded in square meters instead of hectares.

Any input will be appreciated, thanks

SveinungBertnesRåheim · Answer

Take a look at this thread. I got the data expression to work. Summarize table data, joins to feature data, calculate new attribute and visualize with serial chart.

https://community.esri.com/t5/arcgis-dashboards-questions/dashboard-data-expression-with-related-tables/m-p/1338119#M8581

eliotieno · Answer

At first it might seem like a very easy thing to do until you start working on it, I have also been stuck for quite some time, I am no longer sure where we can seek extra guidance

SveinungBertnesRåheim · Answer

Similar to my experience. I had to change "var portal" to something else than portal. The help said portal already was used. If I changed to "portal1" this part worked. But I am stuck... Cant get it work. I want to calculate the percentage of free parking spaces in an ongoing registration project. THat is divde the mean of free car spases on the total amount of free car spaces. But I am coming no way.
Data expressions are not as easy as I hoped them to be....