How to use broad date range in decision report macro

[Elizabeth McCune]

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_]

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.

[Brant Schroeder]

@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

[Elizabeth McCune]

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.

[Pramodh M]

Hi @Elizabeth McCune 

Welcome to Confluence!!

Could you try functions in your instance and let me know if it's working?

https://developer.atlassian.com/server/confluence/cql-function-reference/#CQLFunctionReference-startOfMonth

We could use startOfMonth("-2")

Let me know

Thanks

[Elizabeth McCune]

sadly same performance @Pramodh M