Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

ITSM Time series Graphical report without averaging/summing up records

NishONish
Tera Expert

Hello All,

 

I have a custom table in which I have all records which I wish to show on a time-series graph. for e.g. A metric which has nos over 12 months in a year like-

Jan-25          25

Feb-25           21

Mar-25          20 and likewise 9 more records for 2025 year. 

Now I wish to just create a timeseries graphical report i.e. Months on X-axis and nos on Y-axis. However when I go into Reports module (in Usage and Governance header under Platform Analytics admin header) and create new report , provide name etc and follow Next Next and reach Configure tab (refer attached image) where I need to select Group, Calendar, Per and Aggregation.

 

Now my Qs: Under Aggregation, I only have options Count, Average, Sum, Count Distinct, Maximum, Minimum, and Standard Deviation (refer attached image). I do not need any of these for my use case as I just wish to present nos on graph. Which Options I should choose here OR which other methos I can use to build this report to satisfy my use case please? thank you all

0 REPLIES 0