Add missing column after Pivot
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.
Calculate a running total
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.
Calculate row number
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.
Count distinct totals and percentages
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.
Dynamic categorical columns
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.
Extract parts of a string
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.
Filter Action examples
To compare relationships between columns, use a Filter Action in the Pipeline to organize your data based on conditions.
Filter "Is one of" with Dropdown
Filter your chart with a Dropdown using "is one of" logic in the Visual SQL Pipeline.
Find the date difference between rows
To find the date difference between rows, add a Calculated Column and use the 'date difference' formula.
Group & Aggregate example
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.
SQLite date and time functions
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 string functions
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 CASE statements
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.