Group by Execution date

[arunsnmimt]

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

[GlideFather]

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:

Maybe it's a custom or dotwalked field?

[arunsnmimt]

Hi @GlideFather ,

Thanks for your reply.

• Data source: change_task with filters applied.
• You are trying to group by Execution Date.
• Preview for change_task data works fine, but when grouping by Execution Date, the result shows separate entries for each timestamp instead of grouping by date.
• Example output: or vertical chart.

  12/15 - 10
  13/15 - 11
  14/15 - 2

• The problem seems to be that the Execution Date includes time, so grouping is happening at the datetime level, not just the date.

[Art Sobczak]

group by date has always been a pain in servicenow. Can you do a timeseries instead? maybe a bar chart for the 7 days, it'll yield one bar for each day and show the total. If you need to see the actual records, you double click that day and they'll show up. 

[arunsnmimt]

Tried the same. But no luck.If i try "single score" instead of vertical bar ,i am getting total count.