AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

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

Filter by two date fields issue

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hey guys,

 

I'm fighting with this issue for a couple days already and haven't yet found  a working solution. Maybe anyone can help me here.

 

I have a DB in MySQL. 

It has records and for simplification let's say there are three columns:

1. id

2. date 1

3. date 2

 

What I want to do is to filter out all the ids where date 1 and date 2 were within the same month in given time period.

 

And here it starts:

- filter criteria cannot take into account other fields

- when I try to create calculated field with CASE WHEN it doesn't want to take as criteria MONTH(date 1) = MONTH (date 2). And even throws Invalid Formula error for MONTH (date 1) > 1, even though it shows values as integers if to add MONTH (date 1) as dimension.

 

I feel like I'm missing something fundamental or just fighting against broken connector to MySQL. Any help really appreciated.