# FAQ: Data Studio & Reports

### **How to analyze the fail rate in the communication channels**

{% embed url="<https://www.youtube.com/watch?v=zK99YkIHpBc>" %}

### **How can I export the data to Excel**

Switch to the "Table" presentation of data and click on the "CSV" icon in the top area of **the** table. Be sure that you have the "collapse rows" flag set in order to have a flat table presentation without groping.

<figure><img src="https://lh5.googleusercontent.com/cqycM_-_9VBa6iB1p0wRy7GUBYMunuQPpnXFXYPPXv3MEt4G7oNshVHELxaIKrsi7OB_zBwRqfbXvMbkbSXDc7HLOiiDp2mQRnSwsYXjg7RQzj3Jbpz24e1kEQlATcD9a9ZDJgIkGsTJxypg7uWn1ZRk2hTDZgBXoNakL6fE7Pv2LyYoDB7whS7l" alt=""><figcaption></figcaption></figure>

### **How to open CSV file in Excel**

If you open CSV in Excel and the data is not set in the proper columns automatically, use the button "Text to columns" in the upper menu of Excel.

<figure><img src="/files/SUCnh7hy2fXDksGzORW0" alt=""><figcaption><p>Format CSV file in the columns</p></figcaption></figure>

### **I cannot find the specific record in the view, I only see 5 rows**

When you are using "Dimensions", by default only 5 records will be shown per group. You can click on the dimension name and select to show more records

<figure><img src="https://lh6.googleusercontent.com/tsOAHStunjznNs2ldgr0FxpaqCDXRRi8r0CSVvdOxMU9STr023sVRWJDmF-djVSkPfhkQuqkAO5May4fP9OxOrJtP23eNRtlA8LtW9DRHCAQ8xqRj-4JaYXmbIID0YDx5X4RNZYYqV8DpaD98HEhqGfg85y0jwOYqTw-SusMHeT0Ddg544IPoJlT" 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://help.smartico.ai/welcome/products/faqs/faq-data-studio-and-reports.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.