Time dimension using columns instead of raws
I'm trying to create a new G Data Studio dashboard for my weekly e-commerce reports.
I created a G Sheet where KPIs are placed into raws and time dimension (week: W1, W2 etc.) is placed into columns (please see the image below):
When I connect Data Studio with my G Sheet, it cannot find any valid Time Dimension. Why?
It seems like G Data Studio considers only dimensions placed into raws.
My need is to create a dashboard with graphs like this one below (I simply made it on G Sheet after selecting "switch raws and columns" option).
Unfortunately I cannot place time dimension (weeks) into raws.