I would say that they were originally designed to handle data analysis calculations, which in part, naturally involve visualizing data. But as it turns out, they have far broader use cases....
Thanks for pointing this out! You're right; the legacy CE doesn't treat LIKE in the optimize for unknown case as it does BETWEEN, rather uses the formula you mentioned:
C * (...
Thanks, Paul! This is much appreciated.