I have Looker Studio connected to data stored in google sheets.
The data concerns Actual Turnover and Budgeted Turnover over several years and is stored in a format similar to this sample (with random figures).
https://docs.google.com/spreadsheets/d/1Nmh7ATrBrIazkALPkI09uGpE3KqQVKCSezbnBi5_gXc/edit?usp=sharing
I would like to create a Scorecard and using a calculated field, show what pecentage of the budgeted Turnover the actual turnover is. I read somewhere that I would have to change how the source data is laid out and have the actual and budgeted turnovers in separate columns but is this the case? If possible, would like to avoid having to change the structure of the source google sheet.
Thanks!
Solved! Go to Solution.
Hi,
you can achieve through Data Blending.
you can refer this Lookerstudio report with edit permission using your sample data https://lookerstudio.google.com/reporting/fb15e7bb-0408-4337-87c2-5196e760f5e6
Shijith Pulikkal - Xtract Studio
User | Count |
---|---|
2 | |
1 | |
1 | |
1 | |
1 |