question Report Time Series Active Records by month in ServiceNow AI Platform forum

Report Time Series Active Records by month

NabinC — Mon, 06 May 2024 07:57:36 GMT

Hello,

I am trying to create a time series report that provides the total number of active observations for each month.

The x axis will be a monthly timeline, and the y axis the total number of active observations. I have created similar graphs, leveraging group by and trend by.

For my previous graphs, I kept group by as --none-- and used trend by to see observations that have been closed, created or are overdue for each month.

Unfortunately trend by in a time series doesn't allow me to use the Active field, and if I group by Active and try to trend by any other values, I do not obtain the result I require.

Re: Report Time Series Active Records by month

AndersBGS — Mon, 06 May 2024 09:01:16 GMT

Hi @NabinC ,

If you're trying to "create a time series report that provide the total number of active observations by month", when don't you just create a report based on observations with the conditions that "active is true"? Based on this condition you can create a time series report to fit your need.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

Re: Report Time Series Active Records by month

NabinC — Mon, 06 May 2024 12:52:49 GMT

Hi Anders, thank you for your reply. Unfortunately that would not solve the problem, in any implementation case. I will give you more context, I have created the followings reports, which consists of 3 datasets.

One is for observations due every month, the other two for observation created and closed each month.

What I would require is to add an additional data set with all the active observations for each month. That would mean that an observation is active both on February and March, the graph counter should be +1 for each month for it.