FAQs about the Data Pipeline

  • Advanced Data Pipeline view issues
    If your browser's Page Zoom is not set to 100%, the Advanced Mode Pipeline may look weird or broken. Make sure to set the Zoom to 100% when using Advanced Mode.
  • Advanced sorting
    Measures always take precedence over Dimensions in Chartio; however, insert a Sort Rows step in the Pipeline to re-sort when everything is evaluated.
  • Calculate a percentage
    To calculate a percentage, create two datasets and merge them with a cross join before defining the calculation for the percentage in a new column.
  • Calculate a rolling sum
    A rolling sum can be calculated in the Pipeline by using the Moving Average formula and multiplying it by the number of trailing rows.
  • Calculate a running total
    Calculate a running total for your data by using the Running total preset formula in the Data Pipeline.
  • Calculate row number
    Adding row numbers to data with a rowid column with the Data Pipeline.
  • Change a data type
    Use a cast function in the Custom formula field box to change a data type.
  • Combine columns
    Combine the contents of your columns by using our Combine Columns Pipeline Step or by customizing how they'll be combined using Custom Formulas.
  • Count distinct totals and percentages
    After creating a chart, use the Data Pipeline to alter your data and display values as percentages.
  • Count keywords and characters in strings
    Count the number of times a keyword appears in a column or row or count all characters within a string.
  • SQLite date and time functions
    Using the correct SQL syntax and built-in functions, you can insert date modifiers to change the format, filter, or perform calculations with them.
  • Dynamic dimensions on your dashboard
    In order to dynamically change between dimensions on dashboards, use the Pipeline to define dashboard variables and the effect they have on your chart.
  • Extract parts of a string
    In order to separate two parts of a string, use an Add Column step with a custom formula to extract information from the one column into another column.
  • Extract values from a JSON string
    Learn how to use Chartio's Data Pipeline to extract values from JSON strings.
  • Filter "is one of" with a Dropdown
    Filter your chart on a Dropdown variable list using "is one of" logic in the Data Pipeline.
  • Filter Rows examples
    To compare relationships between columns, use a Filter Rows step in the Data Pipeline to organize your data based on conditions.
  • Find the date difference between rows
    To find the date difference between rows, Add Column in the Pipeline with a datediff custom formula.
  • Forecast your Salesforce pipeline
    Use SQL to find out more about your data source, including historical information.
  • Group email addresses by domain
    To group email addresses by their domain, extract the domain and then group by domain in the Pipeline.
  • Group Step example
    Using a Group Step in the Data Pipeline, you can quickly aggregate rows, like the monthly average of users created per day.
  • Include NULL values when applying functions
    As functions can't be performed on columns of NULL values, use an Add Column step in the Pipeline to convert NULL values to 0 or another column's result.
  • Omit data using an anti-join
    To exclude a large number of rows from your results without using filters, use an anti-join in the Pipeline.
  • OR filter examples
    An OR button will appear after adding at least one filter. You can then drag columns into the OR filter field to yield results for multiple conditions.
  • Round numbers
    Round numbers in your chart by adding a column in the Pipeline and using SQLite functions to write a custom formula to round.
  • SQLite string functions
    SQLite is used in the Data Pipeline, so you can use the SQLite functions to analyze your data.
  • Use CASE statements in queries
    Use a CASE statement in chart queries, dashboard Controls, or in the Pipeline to modify your query results or set conditional logic.