Is there a good way to 'group by' a date/time field in local time?

[MugTm09]

Is there a good way to 'group by' a date/time field in local time?

It seems that although you can handle dates as a time series, you cannot 'group by' year, month, day, hour, or minute.For example, it seems that it is not possible to create a graph that groups data by hour or a graph that displays totals by year.

Is there a good solution to resolve this in Platform Analytics? It seems that 'GlideFunction' is not useful because we need local time, not GMT.

[Bhuvan]

@MugTm09 

You can use trend option to report on this, refer below link for more information

https://www.servicenow.com/community/developer-forum/create-a-report-for-incidents-created-and-group...

https://www.servicenow.com/community/knowledge-managers/group-by-quot-created-quot/m-p/2527683

If this helped to answer your query, please mark it helpful & accept the solution.

Thanks,

Bhuvan

[Ankur Bawiskar]

@MugTm09 

that's correct.

It's not possible as per my understanding.

If my response helped please mark it correct and close the thread so that it benefits future readers.

[AndersBGS]

Hi @MugTm09 ,

To group by year, month, day, hour etc. you should utilize the trend operator: