I am new to data studio and struggling with some bsic things.
So, I have a google sheet with approximately the following format:
| Product | Category | 9/5/2022 | 9/12/2022 | ... |
|---|---|---|---|---|
| Product XXX | Maintenance & Support | 100 | 100 | |
| Product YYY | Development | 100 | 500 | |
| Product ZZZ | Rollout/Deployment | 300 | 200 | |
| Product ZZZ | Rollout/Deployment | 1100 | 200 |
The columns are Product, category of work within product, and then each additional column represents effort spent for a given date on that Product/category combination.
When trying to use this sheet in Google Data Studio, I get Dimensions: Product, Category, 9/5/2022, 9/12/2022,... Where each date is a dimension, but not recognized as a date, rather as different Dimensions. This makes filtering by dates rather difficult. (For example, I cannot just create a control button and ask Data Studio to just select anything from 9/1/2022 --> 9/10/2022, which would include only data for 9/5/2022)
Any advice on how this could be done?
I'd rather not change the google sheet sructure unless necessary.
Ideas? Thank you!!