Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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)
tried this
SUM({<tag_name={"ABC"},[time_created.autoCalendar.Date]={">$(=Date(YearStart(Today()),'YYYY/mm/dd'))"}>} DURATION)
still getting 0 ...
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.