Just an update for everyone.
I managed to design the reports I wanted by using a combination of tag historian queries and scripts as described in this page of the documentation: https://docs.inductiveautomation.com/display/DOC79/Scripting+Data+Source
I found it was super helpful for adding more functionality to historical tags in reporting.
Thanks for all the help.