JIRA JQL in Confluence Templates?

[PeteToscano]

I do a weekly status report in Confluence for my group. At the end, I insert JIRA pie charts showing the status of tickets in a handful of JIRA issues, one chart per project. I'd like to take my normal weekly report and turn it into a template. These charts are all keyed off JQL. Here's the JQL from one of them:

project = FOO and (resolutionDate > "2014-03-04 23:59" or createdDate > "2014-03-04 23:59" or resolution is EMPTY)

I'd like to replace the date/time strings in there with something keyed to one week before the date a report is created from that template. Is that possible with templates? Is it possible with normal values in templates, but not within macros embedded within templates? I guess I could replace the date strings with something like endofday(-7d), but I have a feeling that the values of those funcations will be recalculated whenever someone looks at that report, not be pinned to the date the report was created.

Suggestions?

[Daniel Borcherding]

Pete,

I think your idea of using the offset is a great one. What happens when you do a pdf export of a confluence page containing the pie chart with the date offset. You might have a single master reporting page with a number of pdf attachments that would have snapshots of the data run from the previous week.

[PeteToscano]

Thanks, Daniel. I think that might be a good idea. He doesn't like going to look at the Confluence page anyway, so capturing it all in a PDF and pinning the graphs to that point in time might be a good work aorund.