# 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="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 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>