set expression evaluating to 0

[sekrish]

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)

[Anil_Babu_Samineni]

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)

[sekrish]

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

[Anil_Babu_Samineni]

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.