It sounds like we can add calculated expression fields to “advanced views” in AGOL via the Admin REST API. The view would be uneditable.
"sourceLayerFields": [
{
"name": "zipcode",
"source": "zipcode"
},
{
"name": "salesavg",
"alias": "SaleAveragePerCustomer",
"expression": "(Total_Sales_FY13 + Total_Sales_FY14) / Customers",
"type": "esriFieldTypeDouble"
}
]
LinkedIn video: https://www.linkedin.com/posts/abdillahi-hassan-56a020134_esri-arcgis-ugcPost-7360636518803152896-Nn...
(It also looks like there's some GROUP BY / aggregation functionality in some of the JSON examples too.)
This idea is to create an expression field in a view using the UI, instead of using the Admin REST API, which isn’t user friendly for non-developers.