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

Filters based on calculated fields do not work

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I have a couple of calculated fields, one of them returns boolean (TRUE OR FALSE) based on CASE statement.

 

However, anytime I try to use ANY calculated field in filters I get a server error. Is there guidelines somewhere that state one can not use calculated fields in filters?

Filters based on calculated fields do not work

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

So you're filtering a calculated field by your calculated boolean field?

Filters based on calculated fields do not work

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

I am having the same problem, I have a calculated field like this "WEEK(Date) /4"  it does calculate it, but when I try to filter by it, I get a server error.