Dashboard for Open Jobs

Epicor ERP 10
, ,
21

I got it working. I was having trouble understanding most of the suggestions and plugged away on my own until I came up with this:

Subquery2 has one calculated field with just one result:

Screen Shot 2021-06-23 at 2.09.32 PM
Screen Shot 2021-06-23 at 2.09.32 PM1414×502 40.7 KB

Then the main query has a calculated field which pulls out just the value from Subquery2:

Screen Shot 2021-06-23 at 2.10.58 PM
Screen Shot 2021-06-23 at 2.10.58 PM1070×504 30 KB

Then the dashboard which uses this BAQ filters based on that calculated field. Maybe not the most elegant thing but it is the only thing I could figure out.

My first ever subquery! Thank you everyone for the pointers!

1 Like
22

Nice! Did you verify it is working like you want it to?

23

I am waiting on the person who requested this to verify that the results are correct. Fingers crossed!