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

[mugi-san]

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.

[Ankur Bawiskar · Accepted solution]

@mugi-san 

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.

[Bhuvan]

@mugi-san 

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

[Bhuvan]

@mugi-san 

Thanks for marking the post as helpful.

If my response helped to guide you or answer your query, please mark it helpful & accept the solution.

Thanks,

Bhuvan

[Ankur Bawiskar · Accepted solution]

@mugi-san 

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.

[mugi-san · Accepted solution]

Thanks, @Ankur Bawiskar .

Dear all.

The option to use a 'Data Table' was considered, but we encountered a limitation where percentage values cannot be hidden. As noted in the community link below, this appears to be a design constraint in ServiceNow.
Data visualization seems to be ill-suited for BI use cases.

https://www.servicenow.com/community/developer-forum/how-do-i-remove-percentages-from-tooltips-in-da...