A customer of mine wants to see all stories entered in last 30 days. I already show all stories entered 'today':
table query: SELECT Number, 'Product Name', name WHERE 'Date Created' IS TODAY
But I how do I adjust to show the last 30 days worth?
Thanks!
Bryan
Comments
1 comment
Hi Bryan,
It looks like you've set up a "Date created" property to capture when the card is created. You can use this property in a formula property. If you create a formula property named, "Date Created plus 30" with a formula of:
then you could compare that to TODAY in MQL.
Hope that helps,
Jay
Please sign in to leave a comment.