Reporting

zeeshanahmed
Tera Contributor

‎04-01-2024 01:00 AM

Hello Everyone,

i have the custom table in my instance as below.

 

Interface NameTimestampThroughput InThroughput out
Intenet01-04-2024 09:28:179.696.77
Intenet01-04-2024 09:26:178.235.79
Intenet01-04-2024 09:24:178.235.79
Intenet01-04-2024 09:22:178.175.79
Intenet01-04-2024 09:20:176.824.80
Intenet01-04-2024 09:18:179.586.77
Intenet01-04-2024 09:16:176.874.80
Intenet01-04-2024 09:14:179.586.77
Intenet01-04-2024 09:12:176.824.80
Intenet01-04-2024 09:10:179.636.77
Intenet01-04-2024 09:08:178.175.79
Intenet01-04-2024 09:06:178.235.79
Intenet01-04-2024 09:04:178.335.79
Intenet01-04-2024 09:02:178.125.79
Intenet01-04-2024 09:00:176.924.80
Intenet01-04-2024 08:58:179.636.77
Intenet01-04-2024 08:56:178.235.79
Intenet01-04-2024 08:54:176.914.80
Intenet01-04-2024 08:52:179.596.77
Intenet01-04-2024 08:50:176.824.80
Intenet01-04-2024 08:48:179.596.77
Intenet01-04-2024 08:46:178.175.79
Intenet01-04-2024 08:44:178.235.79
Intenet01-04-2024 08:42:178.235.79
Intenet01-04-2024 08:40:176.914.80
Intenet01-04-2024 08:38:179.606.78
Intenet01-04-2024 08:36:176.904.80
Intenet01-04-2024 08:34:179.546.77
Intenet01-04-2024 08:32:178.275.79
Intenet01-04-2024 08:30:176.924.80
Intenet01-04-2024 08:28:179.536.77
Intenet01-04-2024 08:26:178.435.79

 

I need to create report on this table . Show Timestamp on X axis and Throughput-in & Throughput-out on Y axis . To show the throughput results at particular timestamp.

Issues with the normal reporting : If i Trend by Timestamp and Aggregation(max,min or avg) can be taken per date or per day or per hour or per week, but i want results on each timestamp record. Can this be achievable by any other way or performance analytics . Need some inputs

 

Thanks in advnace 

0 Helpfuls
  • 456 Views
7 REPLIES 7

Sohail Khilji
Kilo Patron
Kilo Patron

‎04-01-2024 01:34 AM

@Dr Atul G- LNG  @AndersBGS  @swathisarang98 

 

Any inputs here ?


☑️ Please mark responses as HELPFUL or ACCEPT SOLUTION to assist future users in finding the right solution....

LinkedIn - Lets Connect

0 Helpfuls

Tai Vu
Kilo Patron
Kilo Patron

‎04-01-2024 03:28 AM

Hi @zeeshanahmed 

Let's give the Trend by per Date a try. It should give you a trend chart with each specific date that represented in the table.

Screenshot 2024-04-01 at 17.26.10.png

 

Sample below

Timi_0-1711967323791.png

 

Cheers,

Tai Vu

0 Helpfuls

zeeshanahmed
Tera Contributor
In response to Tai Vu

‎04-01-2024 03:30 AM

Hi Timi,

I need to Trend by timestamp ,each time stamp should be shown on x-Axis

0 Helpfuls

Dr Atul G- LNG
Tera Patron
Tera Patron
In response to zeeshanahmed

‎04-01-2024 04:14 AM

Hi @zeeshanahmed 

 

I am not sure this is do able, i tired but not working for me.

 

@Tai Vu  Would like to hear from you.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************
0 Helpfuls