topic How to add variable in Table chart Dashboard? in App Development

How to add variable in Table chart Dashboard?

ishansjain2095 — Mon, 20 Dec 2021 21:32:42 GMT

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 — Fri, 13 Mar 2020 09:30:30 GMT

>>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 — Fri, 13 Mar 2020 09:44:36 GMT

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 — Fri, 13 Mar 2020 09:58:12 GMT

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

ishansjain2095 — Fri, 13 Mar 2020 10:28:51 GMT

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