How to create a trend report on a custom field in table

[Neha79]

Hi,

I have a table which stores alert type and its respective alert count. im looking for a trend report (line/spline/area) which shows created time in x axis and alert count in y axis. I can't find any option to show the trend on the count field. Any inputs are appreciated.

Thanks!

[Sohail Khilji]

Hi @Neha79 ,

Did you try using Pivot chart using xaxis as your string and yaxis as the alert count.

Did you start creating were are you struck !

Try this, see if it helps :

https://www.servicenow.com/community/performance-analytics-blog/reporting-on-the-substrings-part-2-3...

[Neha79]

Hi Sohail,

Im looking for a report like the attached one. I've tried the timeseries report types but none of them have the option to show trend on a custom field. 

My data is something like this
Alert            Count     Created

Type1            10        01-01-2024 12:30

Type1            15        01-01-2024 13:00

Type1              5        01-01-2024 13:30