All metrics and breakdowns of data warehouse report saved in one ceel

Question

Hello,When downloading my report with four metrics of the data warehouse, all information is saved in one cell of a row instead of different columns.Like that, it's hard for me to filter my data.As-isPage URL,"Pages","Time Spent on Page > 30 seconds","Time Spent on Page ≤ 30 seconds","Page Views","Visits"https://www.url-a.com/pagename-a.html,"pagename-a","0","1",13,9 https://www.url-b.com/pagename-b.html,"pagename-b","1","0",18,15 Should-bePage URLPagesTime Spent on Page > 30 secondsTime Spent on Page ≤ 30 secondsPage ViewsVisitshttps://www.url-a.com/pagename-a.html pagename a01139https://www.url-b.com/pagename-b.html pagename b101815Can anyone please assit how to set up my report?Thanks, Marie

PratheepArunRaj · Accepted Answer

Dear Marie,Datawarehouse only has CSV and TDE file formats.Mostly Excel detect the CSV file to text the columns. If not, please use the below.It is about how you delimiting the comma's in Excel Editor(Hope you are using Microsoft Excel).1. Open CSV File in Excel.2. Select the column(Only one column now right?) and click "Text To Columns"3. Click on "Delimited" and click next.4. In Delimiters, check "Others" and type comma ",".5. Click "Finish" to see the columns populating correctly.If you are using other editors than MS Excel, I dont have any idea.Thank You!Arun

marieg45657908 · Answer

Wow, thank you Arun. That worked perfectly.

Page URL	Pages	Time Spent on Page > 30 seconds	Time Spent on Page ≤ 30 seconds	Page Views	Visits
https://www.url-a.com/pagename-a.html	pagename a	0	1	13	9
https://www.url-b.com/pagename-b.html	pagename b	1	0	18	15

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded