# Convert No-Code to SQL

This guide will walk you through the process of converting no-code charts into SQL charts using the selected dataset. By following these steps, you will be able to seamlessly transition from a visual representation to a SQL-based query, allowing for greater flexibility and control over your data analysis.

1. Begin by selecting the dataset that you wish to work with. Once you have chosen the dataset, you will have access to all the data within it, which can then be converted into SQL charts.

<figure><img src="/files/rkcDgFfsXpns2pdZn03y" alt=""><figcaption></figcaption></figure>

2. Locate the "Show Editor" button, typically found in the top right corner of the interface. Clicking on this button will grant you access to the editor, where you can make modifications to your charts and perform advanced operations.

<figure><img src="/files/Rq08lFLeAu0bAnZcqG83" alt=""><figcaption></figcaption></figure>

3. Within the editor interface, you will notice a button labeled "View SQL" positioned next to the editor button. Click on this button to access the SQL options related to your chart.

<figure><img src="/files/09U9eLUsRKd3pKn2hR1Y" alt=""><figcaption></figcaption></figure>

4. Upon clicking the "View SQL" button, a popup will appear, presenting you with the option to convert your chart into SQL. Click on the button that prompts you to "Convert this chart to SQL."

<figure><img src="/files/5cCkZF15WQ2Rk0RSqnF9" alt=""><figcaption></figcaption></figure>

5. After that, you can see the No-code converted chart into SQL you can also customize the SQL query as per your choice.

<figure><img src="/files/L7sUSjhPH8JSxW8mV8Ko" alt=""><figcaption></figcaption></figure>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.dapplooker.com/dapplooker-analytics/products/analytics/convert-no-code-to-sql.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.