FAQs about Visual SQL

  • 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.
  • 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.
  • Transition Q&As
    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.