Expression fields (calculated columns) in advanced views seem to be limited to joined views. They don’t work with regular view layers.
For example, concatenate “SEWER-“ text with an integer field to produce prefixed ASSET_IDs like SEWER-0000001.
Documentation: ArcGIS REST APIs > Add to Definition (Feature Service)
Question: Create advanced AGOL view with expression field (no joins)?
Could expression functionality be added to views that don’t have a joined table?