As far I can tell this is not possible. You can set values for the as_of_date for a given role, but it only gives you a calendar prompt from which to pick. I'll ask around IBM and see what I can find out.
Ok thanks! What I've done on our environment is changed the definitions of MTD, YTD and other "to date" filters from the gregorian calendar to use "_add_days($_as_of_date,-1)" instead of the as of date param. So far it has worked fine 🙂
Hi Ryan! Nice video on a nice feature! Thank you! Anyway...I've noticed that even if you've set the _as_of_date parameter to October, 29th, the graph shows data for all the months in the year (up to and including December) - see 08:04. Wasn't it supposed to show nothing for November and December?
E.g. in YTD filter replace reference to $_as_of_date with prompt ('CurrentDate','date', $_as_of_date ) // This is a template expression that is used by the column property 'Lookup reference'. // To pass validation, the line below must remain as a comment. Do not remove the forward slashes. // validate: 1 = 1 #$_this.parent.idForExpression# >= #queryValue($_this.parent.split.ref + '.dYear', $_this.parent.split.ref + '.TheDate = ' + $_as_of_date)# AND #$_this.parent.idForExpression# = #queryValue($_this.parent.split.ref + '.dYear', $_this.parent.split.ref + '.TheDate = ' + prompt ('CurrentDate','date', $_as_of_date ) )# AND #$_this.parent.idForExpression#
@@superdatabros Ryan, we can modify the Calendar filters. I can't publish a screenshot here. Just open any Calendar Data Module and look at its Data items
Want a dynamic _as_of_date? Vote for this idea on the IBM analytics idea's portal! ibm-data-and-ai.ideas.aha.io/ideas/CA-I-3284
Good video Ryan, thanks for sharing
Good one. Can we make the _as_of_date parameter value dynamic?
As far as I can tell the answer is no. But I'll see what I can dig up.
Almost all our reports are as-of yesterday. Would it be possible to change the as of date to always be the previous day?
As far I can tell this is not possible. You can set values for the as_of_date for a given role, but it only gives you a calendar prompt from which to pick. I'll ask around IBM and see what I can find out.
Vote for this: ibm-data-and-ai.ideas.aha.io/ideas/CA-I-3284
Ok thanks! What I've done on our environment is changed the definitions of MTD, YTD and other "to date" filters from the gregorian calendar to use "_add_days($_as_of_date,-1)" instead of the as of date param. So far it has worked fine 🙂
Smart solution!
Hi Ryan! Nice video on a nice feature! Thank you! Anyway...I've noticed that even if you've set the _as_of_date parameter to October, 29th, the graph shows data for all the months in the year (up to and including December) - see 08:04. Wasn't it supposed to show nothing for November and December?
Your video is really good, but the solution by IBM is restrict. The parameter should be in the relative time function, not for the entire dashboard.
Yep.
It is possible though you would have to change all Relative Dates filters to use prompt() instead of $_as_of_date
E.g. in YTD filter replace reference to $_as_of_date with prompt ('CurrentDate','date', $_as_of_date )
// This is a template expression that is used by the column property 'Lookup reference'.
// To pass validation, the line below must remain as a comment. Do not remove the forward slashes.
// validate: 1 = 1
#$_this.parent.idForExpression# >=
#queryValue($_this.parent.split.ref + '.dYear',
$_this.parent.split.ref + '.TheDate = ' + $_as_of_date)#
AND
#$_this.parent.idForExpression# =
#queryValue($_this.parent.split.ref + '.dYear',
$_this.parent.split.ref + '.TheDate = ' + prompt ('CurrentDate','date', $_as_of_date ) )#
AND
#$_this.parent.idForExpression#
@@andreiistomine9893 Can you elaborate on this? Or share an example?
@@superdatabros Ryan, we can modify the Calendar filters. I can't publish a screenshot here. Just open any Calendar Data Module and look at its Data items