I don't see where the relative date filter is coming into play here. Does this query execute okay in Tableau? If so, what's happening afterward that isn't working properly? Can you provide more details?
How do I check if this query was executed right?
This error occurs when I set the RELATIVE DATE filter.
I tried to name one of the db columns as day to see if it would solve and for a while it did. I put to a live version to see if it was able to auto update and now nothing is working at all.
I can't even go back to extract that it gives me an error.
Tell me what details you need and I'll give
I've created a new file to check what's going wrong and I get the same error when I use RELATIVE DATE filter on LIVE CONNECTION with Amazon RedShit.
Did someone go through the same problem?