Report - How to show sum quantity for variable within RITM

JE_KINETIC
Tera Contributor

Hi folks, 

Been working on a report and requesting your reporting wisdom 🙂 
I am trying to have a Column Time Series show the count of assets entered into the RITM (Transfer of Disposable Assets). 
Best I can manage is a count with just the request, but not the count of assets entered. Is this even possible? It is a field where no numerical quantity is entered / selected but asset tags entered in (much like OOB shared mailbox multiple users can be added field). I know everything is a record in a table, just don't know what this table is called. 

I have set it up from Data Table - Requested Item
Type - Time Series Column 
Configure - Group by Variables - Transfer of Disposable Assets - Select Assets from List 

JE_KINETIC_0-1688432757243.png
Is there a way for me to get it to show the count of those asset total, rather than the request? 
Thank you!

 

1 REPLY 1

Ankur Bawiskar
Tera Patron
Tera Patron

@JE_KINETIC 

did you try using function field in reporting?

Report on function fields 

 

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader