Filter in subquery

Jesus shared this question 5 years ago
Answered

Hello everybody,


I have a trouble because i dont achive my filter works in the subquery, i do a union in my report and add a filter calledGOBMX filter but this filter does not work, because the query give me 5,000 rows, when only with the filter should give 365 rows. The filter is a calculated field.


/aTzr9Q9rfdAAAAAElFTkSuQmCC


Replies (3)

photo
1

Hi Jesus,

Thanks for reaching out. Without knowing your data and actual filter setup it's simply not possible to say what's occurring here. You've provided a screenshot of the field being in the report, but can you provide the actual calculation and filter settings? It seems unlikely this would be defective behavior - a filter not providing expected values typically comes down to report setup and/or the data itself.

Regards,

Mike

photo
1

Hi Jesus,

I just wanted to check in and see how things are going with this.

Regards,

Mike

photo
1

Hi Jesus,

I'm going to go ahead and mark this one as Answered since I haven't heard back from you, but if you have further questions or concerns on this, if you respond, it will re-open the case and put it back in my queue and I'll be happy to help.

Regards,

Mike

Leave a Comment
 
Attach a file