Our documentation now lives on the Atlassian Support site at https://support.atlassian.com/analytics/resources/.
What is Visual SQL?
- Cat Africa
Visual SQL is where a bulk of the magic happens—it’s what you’ll use to create your charts. It’s the full series of query and transformation steps taken to achieve your final chart. As the name suggests, we’ve made SQL visual, to empower users of all backgrounds to explore their data. It’s intuitive for business users, fast for power users, transparent for SQL pros, and flexible for programmers.
When you create a new chart, Visual SQL starts with an expanded query step in visual mode where you’ll edit and execute your initial query. From there, you can transform your query result with other Visual SQL steps, view the result sets of those transformations, and ultimately visualize those results to add to your dashboard and share with others.
The image above shows an example series of Visual SQL steps. The “Query” step is first, followed by two “Rename column” steps, then a “Reorder columns” step, then a “Pivot” step, then a “Zero fill” step, and finally a “Chart” step.