ClockInDate

Hey Larry - I did receive data this time (yay?) I am going to check if it is the correct data :thinking:

However, I am receiving row’s twice it looks like it’s picking up two “first” labor dates.

Looking into the data now…

Okay…I am receiving the correct data for the number of set-up’s but I am receiving “jacked-up” dates such as the Min Date of each set-up. How can I tell it I just need the very first set-up?

Thank you!

@Larry-CS Hmmm…Looks like I might be getting somewhere - I’ll update as soon as I can

@banderson Okay…I think I’ve had an epiphany…and I believe that I am almost there. In the picture below I have told my BAQ that I want the set-up times on the jobs that had ClockInDates between two time periods and it did that!

But instead of giving me two lines of data, I want it to add both and give me the totals that I show at the bottom

Once I know how to accomplish this - I’m done (until next time) :slightly_smiling_face:

This is an aggregate function @jpol . So I don’t know what’s all in your BAQ, but I’m assuming that you’ll need a subquery to group and sum your totals, then join to that subquery in your top level to show your totals.

So sum(yourTable.YourField) and group by job number (assuming you want everything on the whole job. Otherwise add whatever other fields you need to add your application groups)

2 Likes