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

Date Range dimension

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi

 

My date range dimension has two columns:-

 

1. PAYMENT DATE

2. DUE DATE/ETA

 

The date is defined in data in both with the same format as enclosed in the screenshots but still, data studio is showing "No date" for Payment date dimension picker and showing data in case of Due Date/ETA data picker.

 

 

Screen Shot 2017-06-15 at 1.55.40 PM.pngScreen Shot 2017-06-15 at 1.55.07 PM.pngScreen Shot 2017-06-15 at 1.54.51 PM.png 

Date Range dimension

Follower ✭ ☆ ☆
# 2
Follower ✭ ☆ ☆

My guess would be that an issue is occuring somewhere in the raw data. 

Date Range dimension

Participant ✭ ✭ ☆
# 3
Participant ✭ ✭ ☆

What's your data source? If it's google sheets, make sure the date is formatted YYYYMMDD (without dashes). 

Date Range dimension

Follower ✭ ☆ ☆
# 4
Follower ✭ ☆ ☆

I've noticed this happening occasionally with new custom events or fresh data. e.g. I can see last 7 days but totally blank for last month.  Try adjusting your timeline to be just "Today" and see if that solves it. If so, something is getting stuck in the raw data or it may just be too new and encounters some null stuff and shuts down instead of loading whatever data it has later.  :/

Re: Date Range dimension

Visitor ✭ ✭ ✭
# 5
Visitor ✭ ✭ ✭
Hi

Thanks for your reply

Let me check to change format