Jonah Adkins jonahadkins

Esri Arcade Labeling Expression

Finds related records between two layers in a web map.

var aTable = $feature.aTableAttributeID;
var relate = "bTableAttributeID = '" + $feature.aTableAttributeID + "'";
var bTable = FeatureSetByName($map, 'bTableNameInWebMap');
var match = Filter(bTable, relate);
var cnt = Count(match);

Esri Arcade Labeling Expression

When today's date is 12/24/36 months from attribute date, label the date with green/yellow/red.

when (
(DateDiff(Today(), $feature.date, 'months') <= 12),
'<CLR green = "255">' + TEXT($feature.date, 'D MMM YYYY') +'</CLR>',
(DateDiff(Today(), $feature.date, 'months') <= 24) ,
'' + TEXT($feature.date, 'D MMM YYYY') +'',

24 : 70.53107625
23 : 141.0621525
22 : 282.124305
21 : 564.24861
20 : 1128.497220
19 : 2256.994440
18 : 4513.988880
17 : 9027.977761
16 : 18055.955520
15 : 36111.911040

	<!DOCTYPE html>
	<meta charset="utf-8">
	<style>

	body {
	background: #fcfcfa;
	height: 500px;
	position: relative;
	width: 960px;
	}

	<!DOCTYPE html>
	<html>

	<head>
	<meta charset='utf-8' />
	<meta name='viewport' content='initial-scale=1,maximum-scale=1,user-scalable=no' />
	<script src='https://api.tiles.mapbox.com/mapbox-gl-js/v0.51.0/mapbox-gl.js'></script>
	<link href='https://api.tiles.mapbox.com/mapbox-gl-js/v0.51.0/mapbox-gl.css' rel='stylesheet' />

	<style>

	<!DOCTYPE html>
	<html>
	<head>
	<meta charset='utf-8' />
	<title>test</title>
	<meta name='viewport' content='initial-scale=1,maximum-scale=1,user-scalable=no' />
	<script src='https://api.tiles.mapbox.com/mapbox-gl-js/v0.44.1/mapbox-gl.js'></script>
	<link href='https://api.tiles.mapbox.com/mapbox-gl-js/v0.44.1/mapbox-gl.css' rel='stylesheet' />
	<style>
	body { margin:0; padding:0; }

	col a format a15 heading 'snapshot\|date'
	col b format a25 heading 'table\|name'
	col c format 999,999,999 'space\|used\|total'

	select
	to_char(begin_interval_time, 'yy/mm/dd hh24:mm') a,
	object_name b,
	space_used_total c

	from