GroupBy and left characters of a field in Dashbord data expression

mfafard

Hi

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://xyz.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

JohannesLindner

Yes, I used test data here...

Your expression would look like this:

var portail = Portal('https://xyz.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"}]
)