Hello Looker Studio Community,
I’m working on visualizing some data from Google Sheets, and I need help with formatting it in Google Looker Studio. Here's the situation:
I have data structured as follows in Google Sheets:
Week Sales Impressions Clicks
2023-W01 | 1000 | 50,000 | 2,500 |
2023-W02 | 1200 | 45,000 | 2,800 |
2023-W03 | 900 | 48,000 | 2,400 |
I want to display this data in Google Looker Studio in the following format, where the metrics (Sales, Impressions, Clicks) are shown in rows, and the weeks (2023-W01, 2023-W02, 2023-W03) are displayed in columns:
Metric 2023-W01 2023-W02 2023-W03
Sales | 1000 | 1200 | 900 |
Impressions | 50,000 | 45,000 | 48,000 |
Clicks | 2,500 | 2,800 | 2,400 |
I’ve connected my Google Sheets data to Looker Studio and set up a Pivot Table, but I am struggling with how to format the data such that:
I’ve tried adding the week in the Columns section and the metrics in the Rows section, but the output isn’t formatted as I want it and Row Dimension does not take more than two dimentions.
Any help or tips on how to format my data correctly in Looker Studio would be greatly appreciated!
Thank you in advance!
@jamshed
1. Pivot table is correctly representing your numbers. Your data is one dimensional hence the given layout.
2. Yes and no. Your example is table and not a pivot table meaning you need to transpose your data first and create a table in looker studio. However, you will need to add each week as separate column which is probably not best idea..
3. You can introduce new dimension to your data but this wont also produce result you require as its going to correctly pivot your data and show all in one row for your dimension.
I suggest try changing your habit from scrolling horizontally to pivotally.
I understand it may be challenging at start but BI are bit different from Spreadsheets.
Regards
Arkady Zagdan
User | Count |
---|---|
3 | |
3 | |
1 | |
1 | |
1 |