topic set expression evaluating to 0 in App Development

set expression evaluating to 0

sekrish — Sat, 16 Nov 2024 17:37:38 GMT

Hi,

I have an app that has a guage control to show data about tickets we receive, the date they are created and the amount of time they take to resolve (among other things). I am looking for the guage needle to show the to total duration for tickets with a particular label but the below expression resolves to 0. any pointers?

SUM({<tag_name={"ABC"},[time_created.autoCalendar.Date]={">2021-01-01"}>} DURATION)

Re: set expression evaluating to 0

Anil_Babu_Samineni — Mon, 11 Jan 2021 20:09:35 GMT

Please check the format and try like this

SUM({<tag_name={"ABC"},[time_created.autoCalendar.Date]={">$(=Date(YearStart(Today()),'Your Format of the field'))"}>} DURATION)

Re: set expression evaluating to 0

sekrish — Mon, 11 Jan 2021 20:32:22 GMT

tried this
SUM({<tag_name={"ABC"},[time_created.autoCalendar.Date]={">$(=Date(YearStart(Today()),'YYYY/mm/dd'))"}>} DURATION)
still getting 0 ...

Re: set expression evaluating to 0

Anil_Babu_Samineni — Mon, 11 Jan 2021 20:35:56 GMT

Try to debug by yourself like

Date(YearStart(Today()),'YYYY/mm/dd')

What is this returning? If that returns something find out the way If they are in same format and available in that field. If ok then it should work.