Documentation Visual SQL (beta)

FAQs about Visual SQL

We try to answer all the most frequently asked questions on visual sql (beta) here, but if you have a fresh one, send us a note at support@chartio.com or open a chat below. We’re always looking to add more!

If your result set is missing a value you'd expect to see from a column, that value won't be visible when you use a Pivot Action. Here's how you can always include all the distinct values in a pivoted column.

Grouped columns are added to the Query Sort in the order they're added to the Query. Aggregated columns must be added manually. You could also use a Sort Rows Action to re-sort when everything is evaluated.

To calculate a percentage, create two queries and merge them with a Cross Join before defining the calculation for the percentage in a new column.

A rolling sum can be calculated in the Pipeline by using the Moving Average guided formula and multiplying it by the number of trailing rows.

Use either the Running Total built-in autocomplete formula or a SQLite window function in a Custom formula to calculate the running total for a column.

Use the Visual SQL pipeline to add row numbers to data with a rowid column.

Use cast() or divide() in a Calculated Column or Edit Formula Action to change a column's data type.

Combine the contents of your columns by customizing how they'll be combined using Custom Formulas.

To compare different periods of time, you can use the Visual SQL Pipeline to find the difference between the periods and visualize it on a Single Value chart.

Show the totals row in your Table chart and add a Calculated Column to apply the Ratio of Total to each row, which gives the percentage each row contributes to the total column's aggregation.

Use Custom Formulas and other Actions to count the number of rows a keyword appears in a column or count the number of characters in a string.

In order to dynamically change between categorical columns on dashboards, use the Visual SQL Pipeline to define Dashboard Controls and the effect they have on your chart.

In order to separate two parts of a string, use a Calculated Column with a Custom formula to extract information from the initial column into another column.

Learn how to use the Visual SQL Pipeline to extract values from JSON strings.

To compare relationships between columns, use a Filter Action in the Pipeline to organize your data based on conditions.

You can filter your charts by full days using Relative Date Variables in Visual Mode or editing the query in SQL Mode

Filter your chart with a Dropdown using "is one of" logic in the Visual SQL Pipeline.

To find the date difference between rows, add a Calculated Column and use the 'date difference' formula.

Using a Group & Aggregate Action in Visual SQL, you can quickly aggregate rows, like the monthly average of users created per day.

To group email addresses by their domain, extract the domain and then group by domain in the Visual SQL Pipeline.

As functions can't be performed on columns with NULL values, use a Custom formula to convert NULL values to 0 or another column's result.

To exclude a large number of rows from your results without using filters, use an anti-join in the Visual SQL Pipeline.

Round numbers in your chart by adding or editing a column in the Pipeline and using SQLite functions to write a Custom formula to round.

Using the correct SQL syntax and our built-in functions, you can use date modifiers to change the format, filter, or perform calculations with them.

SQLite is used in the Visual SQL Pipeline, so you can use the SQLite functions to analyze your data.

Here are our answers to some common questions we've received about the differences between our old Data Explorer interface and our new Visual SQL interface.

Use a CASE statement in your Visual SQL chart queries, Dashboard Controls, or in the Pipeline to modify your query results or set conditional logic.