SHOPLOAD - Who out there uses it, and how?

[tmat (Tracy Smith)]

I did it a while ago but think I got a lot of information from this post:

BAQ using Shop Load

There is a trick that sometimes allows importing BAQs from “latter” versions Someone else posted these steps before me but… I can’t find that original link. Here is the general idea: a.) Copy & rename your BAQ export with the extension “.zip” b.) Open the “archive” with 7-Zip c.) Find the the file BAQVersion in the archive, open with notepad, edit the version numbers to match your target system and save to the zip archive [image] d.) Remove .zip extension from the file name of the copy. …

I’ve attached one version of our BAQ as we use one specifically for Resource Groups (production areas) and one for Resource (specific to tools). You will definitely need to review them against your setup \ jobs for anything we may have missed.
ShopLoad_RG_Daily.baq (89.7 KB)

[knash (Ken Nash)]

Thanks for the assist.

ShopLoadRG.baq (87.1 KB)

Took what you had and did a CTE to extract the hours and date from those strings. Attaching the BAQ to show the additions.

I didn’t refactor the query but you get the idea. Now I am going to create a summary layer, but that should be easy to do.