Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Group by Execution date

arunsnmimt
Kilo Contributor

Hi Team,

I’m working on a Change Task Dashboard in new Platform Analytics team. Currently, I have several CTASKs scheduled for future dates, and I’d like to group them by execution date to display the number of CTASKs scheduled per day for the next week (using vertical bar charts).

The challenge I’m facing is that the execution date includes a timestamp, which prevents me from grouping by the date portion alone.

Could you please advise on the best way to achieve this?

Thanks,A

1 REPLY 1

GlideFather
Tera Patron

Hi @arunsnmimt,

 

could you provide more details? I wanted to simulate it in my instance and there's no such a field at the Change Task [change_task] table:

GlideFather_0-1765469953782.png

 

 

Maybe it's a custom or dotwalked field?

_____
No AI was used in the writing of this post. Pure #GlideFather only