Latest Contributions by aroininen

‎03-09-2021

Hello Again, I had a bit of a break though I am able to display total units by Status with this expression!: Problem is if I keep adding more fields for statistics (i.e Semi, Row) the result is always the last Groupby I tried editing the last statement to add more stats to result but I get nothing here is the expression I am using: I don't need to order this but if I remove it doesn't work that why I just use top 10 var planstat = FeatureSetByName($map,"Planning_Layers - Development Applications - master", ['PRStatus', 'Units', 'SingleD'], false) var treeList = groupBy(planstat, "PRStatus", {name:"count", expression:"PRStatus" , statistic:"COUNT"}) var treeList = groupBy(planstat, "PRStatus", {name:"count", expression:"Units" , statistic:"SUM"}) var topFeatures = Top(OrderBy(treeList, "count desc"),10) var treeList = '' for (var topFeature in topFeatures) { treeList += topFeature.PRStatus +" (" + topFeature.COUNT + ")"+ TextFormatting.NewLine } return treeList If I get this last bit figured out that would be great but I can live with what I have too Thanks again community!

‎03-06-2021

Thanks for all your help Josh but I cannot work out this syntax for the return... I will keep trying.. var planStat = FeatureSetByName($map,"Planning_Layers - Development Applications - Master", ['PRStatus', 'Units', 'SingleD'], false) var stats_list = [ { name: 'Count_PRStatus', expression: 1, statistic: 'COUNT' }, { name: 'Sum_Units', expression: 'Units', statistic: 'SUM' }, { name: 'Sum_SingleD', expression: 'SingleD', statistic: 'SUM' }, ] Return GroupBy(planStat,"PRStatus", stats_list); error Execution Error: Illegal Value: GroupBy or this way - Return; GroupBy(planStat,"PRStatus", stats_list); gives me this: thanks again Aaron

‎03-05-2021

I was able to adjust my original expression to no use intersect though! the one that just returns PLSatus Counts Thanks!

‎03-05-2021

keep getting error Execution Error: Illegal Value: GroupBy This is the layer in the map that I am using the expression on: Planning_Layers - Development Applications - Master should this be something different like the map name...? var planStat = FeatureSetByName($map,"Planning_Layers - Development Applications - Master", ['PRStatus', 'Units', 'SingleD'], false) var stats_list = [ { name: 'Count_PRStatus', expression: 1, statistic: 'COUNT' }, { name: 'Sum_Units', expression: 'Units', statistic: 'SUM' }, { name: 'Sum_SingleD', expression: 'SingleD', statistic: 'SUM' }, ] GroupBy(planStat,"PRStatus", stats_list) Return stats_list thanks!!

‎03-05-2021

my apologies what am I not doing...? Thanks var planStat = (FeatureSetByName)($map,"Planning_Layers - Development Applications", ['PRStatus', 'Units', 'SingleD'], false) var stats_list = [ { name: 'Count_PRStatus', expression: 1, statistic: 'COUNT' }, { name: 'Sum_Units', expression: 'Units', statistic: 'SUM' }, { name: 'Sum_SingleD', expression: 'SingleD', statistic: 'SUM' }, ] GroupBy(planStat,"PRStatus", stats_list) I get this Execution Error: h.charAt is not a function

‎03-05-2021

WOW thanks!!!! close!! (FeatureSetByName($map,"Planning_Layers - Development Applications", ['PRStatus', 'Units', 'SingleD'], false) var stats_list = [ { name: 'Count_PRStatus', expression: 1, statistic: 'COUNT' }, { name: 'Sum_Units', expression: 'Units', statistic: 'SUM' }, { name: 'Sum_SingleD', expression: 'SingleD', statistic: 'SUM' }, ] GroupBy("PRStatus", stats_list) Return Stats_list what did I miss?

‎03-05-2021

Hello Again folks, I feel I may be exhausting my question limit - much appreciation to the community - I am looking into a course. I'm trying to summarize a field in arcade and get statistics from the other fields for a result similar to this: Is this possible in Arcade? I have looked a Paul Bakers post and the Spanish one and many others but I just can't seem to make anything work I think Groupby is the option but I just don't know get the sums from the other fields also do I need to use intersect as I want to get results from the whole dataset if so I can intersect with the municipal border as all developments are within I got this far with this expression (excuse the radon variables!): var intersectArea = Intersects(FeatureSetByName($map,"Planning_Layers - Development Applications"), $feature) var treeList = groupBy(intersectArea, "PRStatus", {name:"count", expression:"PRStatus" , statistic:"COUNT"}) var topFeatures = Top(OrderBy(treeList, "count desc"),10) var treeList = '' for (var topFeature in topFeatures) { treeList += topFeature.PRStatus + " (" + topFeature.count + ")" + TextFormatting.NewLine } return treeList Thanks again Aaron

‎03-05-2021

Thank so much this helped!!

‎03-04-2021

Hello again folks I created a Groupby expression in arcade that shows the results I want and it works when I test GroupBy($layer, ['PRStatus'], [ { name: 'Total', expression: 'PRStatus', statistic: 'count' } ]) When I add this expression to the popup I get a "No Information available" result, other fields are not displayed either I would like to display the summery of the PR status field for the whole dataset (not the ROWID if possible) Thanks again for your time Aaron results from TEST: when I add this expression to the popup I get this result, other fields are not displayed either popup

‎03-02-2021

My bad - I had the $mapp \layer wrong! nailed it!! Thanks for all your help - I will click solved!!

Online Status	Offline
Date Last Visited	‎03-09-2021 03:20 PM

My Ideas

Latest Contributions by aroininen

Re: Summarize table in arcade for Popup

Re: Summarize table in arcade for Popup

Re: Summarize table in arcade for Popup

Re: Summarize table in arcade for Popup

Re: Summarize table in arcade for Popup

Re: Summarize table in arcade for Popup

Summarize table in arcade for Popup

Re: AGOL popup displays 'no info avail' when using arcade expression

AGOL popup displays 'no info avail' when using arcade expression

Re: Arcade if/or/default statements