topic Re: GroupBy and left characters of a field in Dashbord data expression in ArcGIS Dashboards Questions

GroupBy and left characters of a field in Dashbord data expression

mfafard — Fri, 28 Jun 2024 16:53:51 GMT

The following code work. But hard to believe that I can't groupby the 4 left characters of field "nojob"...

I tried lot of scenario, without success

var portail = Portal('https://xxxxx.ca/portal');
var fs = FeatureSetByPortalItem(
portail,
//itemid layer jobsignalisation
'250b512105df48169e8d01xxxxxxxxxx',
//layer id
0,
[
'nojob'
],
false);

var group_exp = [
{ name: 'jobsparannee', expression: 'nojob', statistic: 'COUNT'}]

return GroupBy(fs,['nojob'], group_exp)

return fs

Re: GroupBy and left characters of a field in Dashbord data expression

JohannesLindner — Wed, 24 Jan 2024 22:23:17 GMT

var fs = Featureset({ fields: [{name:"nojob", type:"esriFieldTypeString"}], features:[ {attributes: {nojob: "abcdefg"}}, {attributes: {nojob: "abcdabc"}}, {attributes: {nojob: "abcd"}}, {attributes: {nojob: "uvwx"}}, {attributes: {nojob: "uvwxabc"}}, ] }) return GroupBy(fs, [{name: "test", expression: "SUBSTRING(nojob, 1, 4)"}], [{name: "test_count", statistic: "COUNT", expression: "1"}] )

Re: GroupBy and left characters of a field in Dashbord data expression

mfafard — Thu, 25 Jan 2024 12:40:52 GMT

Thank you Johannes, but my field "nojob" come from an attributes rule (year(now()) + - + sequentiel). So, I want to count how many job in 2024, etc.

Re: GroupBy and left characters of a field in Dashbord data expression

JohannesLindner — Thu, 25 Jan 2024 13:33:49 GMT

Yes, I used test data here...

Your expression would look like this:

var portail = Portal('https://xxxxx.ca/portal'); var fs = FeatureSetByPortalItem( portail, //itemid layer jobsignalisation '250b512105df48169e8d01xxxxxxxxxx', //layer id 0, [ 'nojob' ], false); return GroupBy(fs, [{name: "test", expression: "SUBSTRING(nojob, 1, 4)"}], [{name: "test_count", statistic: "COUNT", expression: "1"}] )

Re: GroupBy and left characters of a field in Dashbord data expression

mfafard — Thu, 25 Jan 2024 15:35:37 GMT

Yep, thank you! I didn't think about these two steps (substring then count...)

Re: GroupBy and left characters of a field in Dashbord data expression

JohannesLindner — Thu, 25 Jan 2024 16:27:44 GMT

Glad to help 🙂 If your question is answered, please mark the solution so that this thread shows as answered.