topic Re: How to set the default value of an input number field to current day's date in Dashboard? in Dashboards & Visualizations

How to set the default value of an input number field to current day's date in Dashboard?

Sharma21 — Wed, 15 May 2024 10:25:13 GMT

I have defined a number.input field in Dashboard Studio (Version:9.0.2) so that the user can select a number representing a date (between 1-31). I want the date to be set to current day's date by default when the user opens the dashboard..

But "defaultValue": "$token_curr_date$" in the code below throws error - Incorrect Type. Expected "number"

{

"options": {

"defaultValue": "$token_curr_date$",

"token": "num_date",

"min": 1,

"max": 31

"title": "Select Date",

"type": "input.number"

}

In "dataSources" I have defined below search and token:

"ds_current_date": {

"type": "ds.search",

"options": {

"query": "| makeresults | eval token_curr_date=strftime(now(), \"%d\") | fields token_curr_date"

"token": "token_curr_date"

}

How do set the default value of input.number to current date?

Re: How to set the default value of an input number field to current day's date in Dashboard?

richgalloway — Wed, 15 May 2024 12:25:30 GMT

The strftime function returns a string rather than an integer expected by defaultValue. Try converting the string into a number.

... "options": { "query": "| makeresults | eval token_curr_date=tonumber(strftime(now(), \"%d\")) | fields token_curr_date" }, ...

Re: How to set the default value of an input number field to current day's date in Dashboard?

Sharma21 — Thu, 16 May 2024 03:58:16 GMT

Not working still. I am thinking that its not even recognizing the token value. Anything wrong with the way I am defining the token or maybe I need to initialize it before it can be referenced?