Data Studio
3.6K members online now
3.6K 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.