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.

[AndersBGS]

Hi @mugi-san ,

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

[mugi-san]

Dear all.

Thank you for your replies. Unfortunately, the current time series visualization feature you mentioned doesn't meet our users' needs.

ServiceNow is not a spreadsheet software, so visualization capabilities are limited.

Therefore, we're continuing to explore better ideas...

[mugi-san]

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.