Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Cancel
- Home
- :
- About KenBuja
KenBuja
MVP Esteemed Contributor
since
07-04-2014
yesterday
4823
Posts created
302
Kudos given
940
Solutions
2220
Kudos received
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
My Ideas
(6 Idea Submissions)Latest Contributions by KenBuja
|
POST
|
Here's one way to calculate the difference (this shows the number of days since the beginning of the year). Note that the month number in the Date function is 0-based (0 is January) function StringToDate(input) {
var arrDate = Split(input, "/");
return Date(arrDate[2], arrDate[1] - 1, arrDate[0]);
}
var date1 = "01/01/2025";
var date2 = Text(Now(), "DD/MM/Y"); //gives today's date as dd/mm/yyyy
Floor(DateDiff(StringToDate(date2), StringToDate(date1), "days")); If your goal is to put this number into an indicator, then you have to return a FeatureSet containing that number function StringToDate(input) {
var arrDate = Split(input, "/");
return Date(arrDate[2], arrDate[1] - 1, arrDate[0]);
}
var date1 = "01/01/2025";
var date2 = Text(Now(), "DD/MM/Y"); //gives today's date as dd/mm/yyyy
var days = Floor(DateDiff(StringToDate(date2), StringToDate(date1), "days"));
return FeatureSet(
{
fields: [{ name: "Days", type: "esriFieldTypeInteger" }],
features: [{ attributes: { Days: days } }]
}
);
... View more
09-24-2025
01:00 PM
|
0
|
0
|
198
|
|
POST
|
First, check all the field names. I may have overlooked changing one back to your schema. Click the Run button in the Arcade editor to see if it's returning a FeatureSet. Add some Console messages to see what the code is doing a various intervals. This should help you figure out what's going wrong.
... View more
09-24-2025
07:55 AM
|
0
|
2
|
163
|
|
POST
|
It looks like it's selective. I still get the error.
... View more
09-23-2025
10:34 AM
|
0
|
0
|
344
|
|
POST
|
That code should be var features = FeatureSetByName($map, 'Kartirane geoloske jedinice', ['PreferisanaStarost'], true);
Distinct(features, 'PreferisanaStarost');
... View more
09-23-2025
09:52 AM
|
0
|
0
|
134
|
|
POST
|
When posting code, please use the "Insert/edit code sample" button. It's easier to read and copy the code. A data expression must return a FeatureSet. Your code just returns an array of text strings. // Portal URL
var portalURL = "https://gis.(COMPANY_NAME).com/portal";
// Feature Layer ItemID
var layerItemID = "itemID";
// Layer index (usually 0)
var layerIndex = 0;
// Fields to include
var fields = ["T4PERMIT", "COMMODITY1", "OD", "Length_Miles"];
// Get FeatureSet from portal item
var fs = FeatureSetByPortalItem(
Portal(portalURL),
layerItemID,
layerIndex,
fields,
false
);
var grouped = GroupBy(
fs,
["T4PERMIT", "COMMODITY1", "OD"],
[{ name: "TotalMileage", expression: "Length_Miles", statistic: "SUM" }]
);
var finalResults = [];
for (var permit in Distinct(grouped, "T4PERMIT")) {
var permitVal = permit["T4PERMIT"];
var permitGroup = Filter(grouped, "T4PERMIT = @permitVal");
var textBlock = "<b>T4 Permit:</b> " + permitVal + "<br>";
for (var comm in Distinct(permitGroup, "COMMODITY1")) {
var commVal = comm["COMMODITY1"];
textBlock += " • <b>Commodity:</b> " + commVal + "<br>";
var commGroup = Filter(permitGroup, "COMMODITY1 = @commVal");
for (var row in commGroup) {
textBlock += "  ◦ <b>OD:</b> " +
row["OD"] +
" – <b>Mileage:</b> " +
Round(row["TotalMileage"], 2) +
"<br>";
}
}
Push(finalResults, { attributes: { Permits: textBlock } });
}
return FeatureSet(
{
fields: [{ name: "Permits", type: "esriFieldTypeString" }],
features: finalResults
}
); Using my test data, the code produces this list
... View more
09-23-2025
08:38 AM
|
1
|
5
|
315
|
|
POST
|
This goes back to my previous post How you get the features variable depends on where you're using the Arcade code. It could be using the variable $datastore or $layer. Or you might need to get it from a function like FeatureSetByName or FeatureSetByPortalItem What happens when you use "$datastore"?
... View more
09-23-2025
08:16 AM
|
0
|
0
|
140
|
|
POST
|
The Distinct function for FeatureSets has the syntax Distinct(features, fields) with the "features" variable being a FeatureSet and the "fields" variable being either a single field name or an array of field names. How you get the features variable depends on where you're using the Arcade code. It could be using the variable $datastore or $layer. Or you might need to get it from a function like FeatureSetByName or FeatureSetByPortalItem What do you get if you use this in your code? Distinct($layer, "Peferisana starost")
... View more
09-19-2025
09:48 AM
|
0
|
0
|
667
|
|
POST
|
What are you trying to do with this code? This affects what profile variables and functions you're able to use in your code. For example, labeling and visualization gives you a very limited set of profile variables and function bundles for efficiency reasons, whereas field calculations and popups give you more. In any case, you can't use "$Kartirane geoloske jedinice", since that is not a FeatureSet variable.
... View more
09-19-2025
06:03 AM
|
0
|
0
|
680
|
|
POST
|
You're using the incorrect syntax for the Distinct function for a FeatureSet. It should be Distinct($layer, 'fieldName')
//or
Distinct($layer, ['fieldName1', 'fieldName2'])
... View more
09-18-2025
10:54 AM
|
2
|
0
|
739
|
|
POST
|
There are a couple of ways to do that. You can put a simple IIf function in the backgroundColor property to change it if it's a certain value. return {
cells: {
Portfolio_1: {
displayText : Text($datapoint.Portfolio_1),
textColor: '',
backgroundColor: iif($datapoint.Portfolio_1 == 1, "#ff0000",""),
textAlign: 'right',
iconName: '',
iconAlign: '',
iconColor: '',
iconOutlineColor: ''
}, which will give you this If you want to apply that logic to several columns, a better way would be to use a function that determines whether the cell should have a red background color, using the value of the $datapoints of the various columns. function bgColor(input) {
if (input == 1) return "#ff0000"
}
return {
cells: {
Portfolio_1: {
displayText : Text($datapoint.Portfolio_1),
textColor: '',
backgroundColor: bgColor($datapoint.Portfolio_1),
textAlign: 'right',
iconName: '',
iconAlign: '',
iconColor: '',
iconOutlineColor: ''
},
Portfolio_2: {
displayText : Text($datapoint.Portfolio_2),
textColor: '',
backgroundColor: bgColor($datapoint.Portfolio_2),
textAlign: 'right',
iconName: '',
iconAlign: '',
iconColor: '',
iconOutlineColor: ''
},
Portfolio_3: {
displayText : Text($datapoint.Portfolio_3),
textColor: '',
backgroundColor: bgColor($datapoint.Portfolio_3),
textAlign: 'right',
iconName: '',
iconAlign: '',
iconColor: '',
iconOutlineColor: ''
},
Portfolio_4: {
displayText : Text($datapoint.Portfolio_4),
textColor: '',
backgroundColor: bgColor($datapoint.Portfolio_4),
textAlign: 'right',
iconName: '',
iconAlign: '',
iconColor: '',
iconOutlineColor: ''
},
Portfolio_5: {
displayText : Text($datapoint.Portfolio_5),
textColor: '',
backgroundColor: bgColor($datapoint.Portfolio_5),
textAlign: 'right',
iconName: '',
iconAlign: '',
iconColor: '',
iconOutlineColor: ''
},
}
} which results in this
... View more
09-18-2025
10:43 AM
|
1
|
0
|
153
|
|
POST
|
It's probably better to submit your feedback through the Basemap feedback map.
... View more
09-18-2025
05:47 AM
|
1
|
0
|
150
|
My kudoed posts
| Title | Kudos | Posted |
|---|---|---|
| 1 | 2 weeks ago | |
| 2 | 3 weeks ago | |
| 1 | 3 weeks ago | |
| 1 | 3 weeks ago | |
| 1 | 4 weeks ago |
Activity Feed
- Posted Re: Coordinate labels in Pro break in online web map on ArcGIS Online Questions. Tuesday
- Posted Re: Trying to create an Arcade Data Expression but is not working properly (Dashboards) on ArcGIS Online Questions. Tuesday
- Got a Kudo for Re: Last date update return from layer. Monday
- Kudoed First Thoughts On The October 2025 ArcGIS Online Update for JeffreyThompson2. a week ago
- Posted Re: Last date update return from layer on ArcGIS Experience Builder Questions. 2 weeks ago
- Posted Re: Last date update return from layer on ArcGIS Experience Builder Questions. 2 weeks ago
- Got a Kudo for Re: Dashboard table - data expression for wide format. 3 weeks ago
- Got a Kudo for Re: Dashboard table - data expression for wide format. 3 weeks ago
- Got a Kudo for Re: Indicator Arcade Assistance. 3 weeks ago
- Posted Re: Indicator Arcade Assistance on ArcGIS Dashboards Questions. 3 weeks ago
- Posted Re: Dashboard table - data expression for wide format on ArcGIS Dashboards Questions. 3 weeks ago
- Got a Kudo for Re: Indicator Arcade Assistance. 3 weeks ago
- Got a Kudo for Re: Indicator Arcade Assistance. 3 weeks ago
- Kudoed Allow admins to specify time range for sort by popularity in gallery for HollyTorpey_LSA. 3 weeks ago
- Posted Re: Indicator Arcade Assistance on ArcGIS Dashboards Questions. 3 weeks ago
- Kudoed "Waffle" menus across all online products for JenniferBorlick. 4 weeks ago
- Posted Re: Indicator Arcade Assistance on ArcGIS Dashboards Questions. 4 weeks ago
- Got a Kudo for Re: Way to get rid of year value in arcade date expression. 4 weeks ago
- Got a Kudo for Re: Way to get rid of year value in arcade date expression. 4 weeks ago
- Posted Re: Way to get rid of year value in arcade date expression on ArcGIS Online Questions. 4 weeks ago
User Groups for KenBuja
Contact Me
| Online Status |
Offline
|
| Date Last Visited |
yesterday
|