...
https://github.com/cul-it/cul-folio-analytics
4 5 - Open the canned_reports or ad_hoc directory, choose Add file/Create new file
...
Enter the CR and number for this query followed by a Slash ( / ) mark, then enter the name of the query you will be submitting followed by a .sql file extension. Make sure the name of the query includes underscore characters between each of the words, and keep the name as short as you can (e.g., loan_count.sql). The Slash mark creates a new directory for this query. Hit the Return key to enter both the new directory and the name of the query file you will be submitting.
6 – Return to the main directory for this query by clicking the CR and number above.
...