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

How can I separate the date and the data? I want to extract in a one row.

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

Is it possible extract two different data from a one row(META_VALUE)?

(You can check my data sheet sample at the bottom.)

 

I want to make 'Date' to Time Dimension. "player" to Metric and count it.

스크린샷 2017-05-24 오후 3.46.53.png

 (*I can't change or edit the sheet)

 

USER_ID /META_KEY                                                /META_VALUE

1First_NameSEO
1Class"subscribed"
1Date2016-12-11 16:20:03
2First_NameROY
2Class"subscribed","player"
2Date2017-01-11 09:10:22

 

How can I separate the date and the data? I want to extract in a one row.

Explorer ✭ ✭ ✭
# 2
Explorer ✭ ✭ ✭

I would start with creating a calculated field in Data Studio and use RegExp_Extract 

 

https://support.google.com/datastudio/answer/7050487?hl=en

 

https://support.google.com/datastudio/answer/6299685?hl=en&ref_topic=7368785