Data Studio
2.6K members online now
2.6K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Calculated metric on time dimension to spit out time dimension without changing date type

[ Edited ]
Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi

 

I would like to add business weeks to my line graphs as opposed to ISO week number/dates. One way I have hypothesised is to perform a calculated metric on my date dimension (counted as time dimension). However, the problem is that this new calculated metric cannot be used on the line graph as it is not a time dimension. I would have to change the data type to one of the date type options, which takes me back to my original problem of having a date/ISO week instead of business week!

 

Thanks

 

Jasmine