cancel
Showing results for 
Search instead for 
Did you mean: 

Dashboard time filter from dynamic TODAY until forever

mccoy1000
7 - Data Storage
7 - Data Storage

Hi.  I have searched and cant seem to find this specific answer and I have tried multiple attempts of using currentdate(), today(), etc.

I need a dashboard time filter that starts TODAY, end date doesn't matter as I can make it 20 years into the future (or just ignore).

{
"from": "2023-02-06",   
"to": "2030-12-31"
}

I need "from": to be dynamic for the actual returned system date.  I know this should be remarkably easy, but as a non programmer I am struggling and cant get past invalid syntax query.  This is going to be embarrasing, but here was my lastest attempt:

{
"from": FormatDate(Today(), "yyyy-MM-dd"),
"to": "2030-12-31",
"custom": true
}

 

1 ACCEPTED SOLUTION

Angelina_QBeeQ
10 - ETL
10 - ETL

Hi @mccoy1000 ,
You can use "next" in the filter. 

Angelina_0-1675779114478.png

Or write the same custom one for the days:

{
  "next": {
    "count": 100,
    "offset": 0
  }
}


Always here to help,
Angelina from QBeeQ
[email protected]
QBeeQ - Gold Implementation and Development Partner

View solution in original post

2 REPLIES 2

Angelina_QBeeQ
10 - ETL
10 - ETL

Hi @mccoy1000 ,
You can use "next" in the filter. 

Angelina_0-1675779114478.png

Or write the same custom one for the days:

{
  "next": {
    "count": 100,
    "offset": 0
  }
}


Always here to help,
Angelina from QBeeQ
[email protected]
QBeeQ - Gold Implementation and Development Partner

Perfect!  Works as advertised.  FWIW "next" "x" days is not an off the shelf option in my org's sisense deployment, so the custom code was needed.  Thank you! This allows the report to filter perfectly as needed for this situation.