> For the complete documentation index, see [llms.txt](https://help.smartico.ai/welcome/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.smartico.ai/welcome/products/tools-and-guides/faqs/faq-data-studio-and-reports.md).

# 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 enabled in order to include grouped dimension columns and generate a flat table presentation without grouping.

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

### **Why is the Grand Total row hidden in the table?**

When the "Collapse rows" option is active to present a flat table, the Grand Total row is automatically hidden in the interface. To inspect the Grand Total in the table view, turn off "Collapse rows". If you need totals for exported CSV files, you can calculate the sum directly in your spreadsheet software.

### **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="https://77049817-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FfS5hl0PiysHtKAKMsQTe%2Fuploads%2Fgit-blob-3cdd086b9fee88613f8894987d5dbdcacfe672ff%2Fimage.png?alt=media" 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 using dimensions, by default only 5 records are shown per group. Click on the dimension name in the split bar to select a higher row limit (such as 10, 25, 50, or 100) or sort by a specific metric.

<figure><img src="https://lh6.googleusercontent.com/tsOAHStunjznNs2ldgr0FxpaqCDXRRi8r0CSVvdOxMU9STr023sVRWJDmF-djVSkPfhkQuqkAO5May4fP9OxOrJtP23eNRtlA8LtW9DRHCAQ8xqRj-4JaYXmbIID0YDx5X4RNZYYqV8DpaD98HEhqGfg85y0jwOYqTw-SusMHeT0Ddg544IPoJlT" alt=""><figcaption></figcaption></figure>

### **Why do some values appear as "undefined" or blank in Data Studio reports?**

When generating reports with multiple group-by dimensions across large volumes of data, the system queries each column sequentially. If processing limits are reached, later columns may stop populating, displaying "undefined" or empty values. To prevent this, reduce the number of simultaneous group-by dimensions, narrow your date range or filters, or use the Data Warehouse for large detailed exports.

### **What does the double tilde (≈) symbol mean next to metrics?**

A double tilde ("≈") next to a metric indicates an estimated count rather than an exact value. This approximation is used for high-volume metrics such as unique active users, allowing the platform to calculate totals instantly across millions of records without scanning every individual transaction. The underlying data remains accurate.

### **How can I export raw player-level or event-level data?**

Data Studio is optimized for aggregated analytics and multi-dimensional reporting. For granular row-level data—such as full event logs, player transaction histories, or user segment lists—use the Event History screen, the User Segments export in Back-Office, or query the Smartico Data Warehouse directly.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## 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, and the optional `goal` query parameter:

```
GET https://help.smartico.ai/welcome/products/tools-and-guides/faqs/faq-data-studio-and-reports.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

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.