Start a new topic

How do I create my own custom date?

Hi :-)


I can't figure out how to set up a custom date that takes data from 16:00 to 15:59 eg.

I can only choose today, yesterday and so on.


Is there any fix for this?

1 Comment

Hi Sebastian,


So for Data Studio your only possible tool for this is filtering with regex expressions on the time based fields. You don't get the custom dates or the time formatting you can do in Sheets. Not all data sources will give a time stamp (though perhaps can have their display settings changed to expose it) and not all will work with this. 

image



So some experimentation is needed.


In Facebook Ads, there's a hour dimension by default, which is convenient. So I can build a really simple regex to get the first two hours (not elegant but shows the point).

image



And the apply that to my table:

image



So I hope this gives you some ideas.


-Thank you

Supermetics Team

Login or Signup to post a comment