How to add variable in Table chart Dashboard?

[ishansjain2095]

Hi All,

Using variable name as 'vTodayDate' i.e.

"=Date(Today(),'YYYY-MM-DD')"

How to map this in table chart for count() function???

Regards,

Ishan

[jonathandienst]

>>How to map this in table chart for count() function???

Its not clear what your mean. Please expand on this request, preferably with an example. To append the variable to a caption or header:

.... & vTodayDate

[ishansjain2095]

Hi Jontydkpi,

I am trying to add date as 'YYYY-MM-DD' in count() function to map tables like to sum of employees I need to find out.

Sharing you a sample example pic as attachment. Please solve the query asap.

Regards,

Ishan

[jonathandienst]

Count({<... , CommonDate = {'$(vTodayDate)'} ...

[ishansjain2095]

Hi,

Thanks for the query but it isn't working. Can you help me how can I user variable to get today's date for the respective tablename.

Regards,

Ishan