We’ve improved autocomplete in Model Builder formulas to make building formulas faster, more intuitive, and less error-prone:

1. Datasets grouped by category – Datasets in the autocomplete list are now grouped by category, making it easier to find the right one quickly.

2. Improved time period filtering –

   • The formula popover now shows “Filter time…” instead of the “.” trigger (the system will insert the “.” operator automatically).

   • Time options are reorganized into clear sections:

     • Relative: Last Month, Last 6 Months, Last 12 Months, Month Last Year, Custom Past Months, Custom Future Months. On actuals, Last Month, Month Last Year, Custom Past Months options are available.
     • Fixed: Specific months (e.g., Jan25, Feb25…)
3. “WHERE” renamed to “Filter rows…” – Selecting this in autocomplete now automatically generates a WHERE clause, making its purpose clearer.
4. Smarter date suggestions – Only relevant date columns are suggested when using functions with the new grammar, reducing errors.
5. Consistent operator styling – Operator groups (variables, datasets, operators, etc.) now appear in lowercase for better readability.