FROM Clause

The FROM clause defines which table or table function to query. CRM Analytics SQL supports using FROM with a single table only. You can’t select from multiple tables.

CRM Analytics SQL supports the following table functions.

• FILL

  Use the FILL() table function to fill in any gaps in date fields. By specifying the date fields to check, FILL() creates rows that contain the missing month, day, week, quarter, or year and null data. Use it with TIMESERIES() to forecast future results when there are gaps in input data.

• TIMESERIES

  Use the TIMESERIES() table function to predict future values based on existing ones tracked over time. Optionally choose a prediction model, confidence interval, and seasonality among other parameters.