How to use broad date range in decision report macro

Question

I want to show decisions from the last two months, not from a specific date so that the same document cane be used but the decisions are rolling. However, it's not clear how to pass cql queries correctly into the custom filter. I've tried now("-90d") and similar but the render always fails. Is there a way to do this?

Katerina Kovriga {Stiltsoft} · Answer

Hi @Elizabeth McCune ,

We can suggest trying our Table Filter and Charts for Confluence app and its Table Filter macro: wrap the Decision Report macro in the Table Filter macro body, set the corresponding date format and use the -3m (-2w, today, etc.) variables.

Hope this helps your case.

Elizabeth McCune · Answer

so that would mean there isn't a way to try and do what I'd like to do? i.e. a customized "two months" or two weeks type deal. I didn't want to pick a hard datetime point.

Brant Schroeder · Answer

@Elizabeth McCune The supported format for the date field in CQL is one of the following 
"yyyy/MM/dd HH:mm", "yyyy-MM-dd HH:mm", "yyyy/MM/dd" or "yyyy-MM-dd" https://developer.atlassian.com/cloud/confluence/cql-fields/#created