--- schema_version: "1" id: ee3bf5988d298bafbb50b029fdec4ce790b3509571db62972047e8603f377873 title: Resolve Errors in Predictive Modelling Functions collection: tableau version: current locale: en-gb portal_url: https://docs.salesforce.com/tableau/current/en-gb/public/desktop/predictions_resolve_errors.md canonical_url: https://help.tableau.com/current/public/desktop/en-gb/predictions_resolve_errors.htm source_site: help.tableau.com content_type: documentation content_hash: 6ed9c224cac8ad1456f9b26ba94609d9ce7024f870be5fd1660defba77d81b48 description: Resolve errors in predictive modeling functions, including Gaussian process errors. --- [Skip to main content](#main-content) # Resolve Errors in Predictive Modelling Functions When using [predictive modelling functions](https://help.tableau.com/current/pro/desktop/en-gb/predictions_overview.htm) in Tableau, you may encounter errors when trying to add the calculations to a viz. Often, this is due to the combination of predictors and visualised elements, leading to a mathematically invalid computation. Generally, the first thing to try is to double check your [Compute Using](https://help.tableau.com/current/pro/desktop/en-gb/calculations_tablecalculations.htm#the-basics-addressing-and-partitioning) dimension. Next, verify there isn't a mismatch between the level of detail specified in your predictors and the level of detail in the view. Also verify that your predictors provide relevant data to the model, given the current visualisation. In this article, we describe several common issues in detail, and the ways in which you can address them. Errors with predictive modelling functions are usually caused by one or more of the following issues, depending on the model used. ### General errors - [Invalid Compute Using dimension](#Invalid_Compute_Using_dimension) - [Dimension predictors conflict with level of detail visualised](#Dimension_predictors_conflict_with_LOD) - [Multiple predictors conflict with each other](#Multiple_predictors_conflict_with_each_other) - [There's not enough data to build a model](#There's_not_enough_data_to_build_a_model) - [A successful model couldn't be constructed from the data provided](#A_successful_model_couldn't_be_constructed) ### Gaussian process regression errors - [Gaussian process regression requires exactly one ordered dimension predictor](#GP_one_ordered_dimension) - [Gaussian process regression only supports dimensions as predictors](#GP_only_dimensions) - [There's no training data for one or more prediction targets](#GP_no_training_data) - [There are more than 5,000 marks](#GP_too_many_marks) #### Invalid Compute Using dimension When visualising a predictive modelling function, a Compute Using dimension must be specified. It’s recommended that you select a specific dimension (such as **Region** or **Category**) rather than a directional dimension (such as **Table Across Then Down** or **Pane Across**). Since you may have multiple predictive modelling functions included in a viz or dashboard, selecting a specific partitioning dimension will help ensure you’re building models using the same underlying data set for each individual function – in other words, comparing results from like to like models. For more information on addressing and partitioning, see [Transform Values with Table Calculations](https://help.tableau.com/current/public/desktop/en-gb/calculations_tablecalculations.htm). When working with predictive modelling functions, you must ensure you maintain consistency across the different instantiations, both in different iterations of your model (e.g. as you select different predictors), and in different vizzes. Using the directional Compute Using dimensions opens up the possibility that a trivial change in your visualised data will significantly affect the data being used to build the model, thus affecting its validity and consistency across different vizzes. You may see [null values](https://help.tableau.com/current/pro/desktop/en-gb/datafields_specialvalues.htm#null-numbers-and-dates-and-negative-values-on-log-axes) if no Compute Using dimension has been specified, or if an invalid Compute Using dimension has been selected. Invalid Compute Using dimensions include: - Cell: This dimension will always result in a single data point being used to build a model and will not be successful. - A higher-level nested dimension (e.g. if Region and State are both visualised on an axis, where marks are generated for State but grouped by Region.) If Region is selected as the partitioning dimension, it will return null values, since there are no marks formalised for Region in this view. ![viz where Compute Using dimensions are State and Category](/tableau/current/en-gb/public/desktop/en-gb/Img/predict-error1.png) _In the above viz, valid Compute Using dimensions are **State** and **Category**. Partitioning the data by **State** or by **Category** yields multiple valid marks that can be used to build a model._ _**Region**, while listed as a Compute Using option, doesn’t generate any marks on this view's level of detail, and can’t be used to partition the data._ For more information, see [Compute Using and Data Partitioning in Predictive Modelling](https://help.tableau.com/current/public/desktop/en-gb/predictions_compute_using.htm). #### Dimension predictors conflict with level of detail visualised Dimension predictors must be at the same level of detail being visualised or _higher_. That is, if you’re visualising data by **State**, you can use **State**, **Region** or **Country** as predictors, but using City as a predictor will cause an error. Since multiple cities exist within a state, this predictor will resolve to \* for all marks and won’t return meaningful information; as such, Tableau ignores it. Each dimensional predictor must be enclosed within an [ATTR function](https://kb.tableau.com/articles/howto/when-to-use-the-attribute-attr-function?lang=en-gb), for example: `MODEL_PERCENTILE(SUM([Sales]), ATTR([State]), ATTR([Category])` #### Multiple predictors conflict with each other Each predictor used within a given predictive modelling function must provide independent information to the calculation. If two predictors are selected that are exactly equivalent, scaled versions or inverses of each other, the predictive modelling function will return an error when it's visualised. For example, a data set that tracks weather conditions over time might have two fields: **IsRain** and **IsClear**. These two fields are inverses of each other; that is, **IsClear** = True when **IsRain** = False, and vice versa. Including both **IsClear** and **IsRain** as predictors on a single predictive modelling function will return an error. The above is true for both measures and dimensions as predictors. In both cases, the error can be resolved by modifying your predictors to remove the highly correlated predictors. For more information, see [Choosing Predictors](https://help.tableau.com/current/public/desktop/en-gb/predictions_choosing_predictors.htm). #### There's not enough data to build a model There must be at least three marks within a partition to allow predictive modelling functions to build a model and generate predictions. If there are two or fewer marks in the data set defined by the viewed data and the Compute Using dimension, then the predictive modelling function will return null results. To resolve this issue, revise your level of detail, your data filtering parameters or your Compute Using dimension, so that each partition has more than two marks. #### A successful model couldn't be constructed from the data provided This error appears if there’s a conflict between the predictor(s) selected, the visualised level of detail and/or the selected Compute Using dimension, such that it is impossible to use the predictors to build a rational model. For example, let’s look at this MODEL\_QUANTILE calculation: `MODEL_QUANTILE(0.5, MEDIAN([Profit]), ATTR(MONTH([Order Date])))` Applying this calculation to a viz where each mark represents a **State** value will return the below error: ![error message](/tableau/current/en-gb/public/desktop/en-gb/Img/predict-error5.png) Since **Order Date** is not used to visualise or segment the data, the predictive modelling function can’t use the predictor specified to build a model. To resolve this: - Update your visualisation to include the predictor as a dimension. - Update your function to remove the non-viable predictor. It’s worth noting that this error reflects a mismatch between the visualisation and the table calculation's specific predictors. This same calculation would work without issue if applied to a visualisation that included **Order Date** as a dimension. #### Gaussian process regression requires exactly one ordered dimension predictor To use Gaussian process regression, you must include exactly one ordered dimension as a predictor. You can include additional _unordered_ dimensions as predictors. Measures can't be used as predictors with Gaussian process regression. If you encounter this error, add an ordered dimension predictor to your table calculation, remove the excess ordered dimension predictor, or specify that one of the ordered dimensions should be treated as an unordered dimension. As Gaussian process regression is best used on time-series data, this will usually take the form of a time-based predictor such as ATTR(DATETRUNC('month',\[Order Date\])). Any [date\_part](https://help.tableau.com/current/pro/desktop/en-gb/functions_functions_date.htm#datepart-values) can be used in the DATETRUNC expression, but the date\_part must be at the same or higher level of detail as the viz. That is, if the viz uses WEEK(\[Order Date\]) as the level of aggregation, the date\_part must be 'week','month','quarter', etc.; it can't be 'dayofyear', 'day', 'weekday', 'hour', etc. Note that because ATTR(MONTH(\[Date\])) returns string values, it will not function as an ordered dimensional predictor unless it is manually specified. This is done by including **"ordered"** immediately before the predictor, as below: `MODEL_PERCENTILE( "model=gp", SUM([Sales]), "ordered",ATTR(MONTH([Order Date])) )` If you want to include multiple time dimensions in your predictors, you must specify which ones you wish to use as unordered dimensions. This can be done by including **"unordered"** directly before that dimension, as below: `MODEL_PERCENTILE( "model=gp", SUM([Sales]), ATTR(DATETRUNC('month',[Order Date])) "unordered",ATTR(DATETRUNC('year',[Order Date])) )` Attempting to use the above calculation without specifying **"unordered"** in front of ATTR(DATETRUNC('year',\[Order Date\]) will return an error. Additionally, the addressing direction (or ‘Compute Using’) for Gaussian process regression must be set to the same field as the ordered dimension predictor. Only one addressing direction (or ‘Compute Using’) can be selected for all models. #### Gaussian process regression only supports dimensions as predictors You can't use any measures as predictors in Gaussian process calculations. Remove the measure predictor. This limitation only applies to predictive modelling functions that specify Gaussian process regression. Linear regression (or OLS, the default) and regularised linear regression functions both support measures as predictors. #### There's no training data for one or more prediction targets Gaussian process regression requires that each data partition has at least _n_ data points in order to build a predictive model and return predictions. If you encounter this error, revise your predictions. #### There are more than 5,000 marks Gaussian process regressions are only supported on vizzes with fewer than 5,000 marks. To resolve this issue, update your level of detail to decrease the number of marks, or select a different statistical model.