<aside> <img src="/icons/home_gray.svg" alt="/icons/home_gray.svg" width="40px" /> Home

Getting Started

Flowtrail AI Chat

Datasource Connection

Connect datasource

Explore datasource

Datasets

Create Dataset

Create Datasets with AI

Datasets with parameters

Reports

Add Reports

Reports with parameters

Publish Reports

Dashboards

Create Dashboards

Publish dashboards

</aside>

How to Create Datasets with Parameters

Datasets with parameters in Flowtrail AI allow you to fine-tune your data queries for more tailored analysis. Follow these steps to add parameters to your datasets:

Step 1: Access the Dataset Screen

• Begin by navigating to the dataset screen within your Flowtrail AI dashboard. Here, you can manage existing datasets or create new ones.

  

Step 2: Add or Edit Dataset

• To add a new dataset, click on "Add New Dataset." Alternatively, click on an existing dataset to edit it.

Step 3: Adding Parameters

• Look for the "Add Parameters" option at the top of the screen and click on it. This will open the parameter configuration interface.

  

Step 4: Name Your Parameter

• Provide a name for your parameter. Ensure it follows valid variable naming conventions, such as 'someVariableName', without spaces.

Step 5: Choose Parameter Type and Configure

• Flowtrail AI offers various parameter types to suit your data needs. Choose the appropriate type and configure it accordingly:

  

  • For String and Number types, input your desired value and set a default if needed.
  • For Boolean, choose between true or false and set a default accordingly.
  • For Date, use the date picker to select a date and optionally set a default.
  • For Select and Multi-select, input options separated by commas and define a default choice if necessary.

  

Step 6: Save Your Parameter Setup

• Optionally, make the parameter mandatory by checking the appropriate box (Required). Once you've configured your parameters, save your settings. You can add more parameters by following these steps for each new one.

  

Using Parameters in Queries

• After adding parameters, you can utilize them in your query by referencing . This allows for dynamic customization of your dataset based on user-defined inputs.

  

Executing Queries with Parameters

• Select the parameters from the top section of the query editor. If any default values are configured for the parameters, the query can be executed directly. Alternatively, you can manually choose parameter values from the top section before executing the query.

  

Handling Non-Mandatory Parameters

• If parameters are not mandatory, it's advisable to incorporate if conditions in your query logic. This ensures that the execution does not break if certain parameters are not provided, maintaining the integrity of the analysis process.

  

Note: Parameters enable dynamic adjustments to your dataset queries, enhancing flexibility and customization for your data analysis needs.