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.

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.

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

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.

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.

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

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.

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.