Tracking Consumable Levels Over Time

[Tom104]

Hi All,

I've had a requirement to check the quantity of consumables over time in our stockrooms.

Essentially, I need a line report that shows a trend per day in consumption of the device.

In this example, headsets. I need to see that I start on 01/01/2024 with 60 headsets in stock, and see that drop to 50 on 01/02/2024.

Is there any way to track this in ServiceNow? I can't seem to gather the data.

[HDLawrence]

As far as I can tell, the only 'true' way to do this would be with performance analytics.

Reporting only looks at the current state of records and since consumables don't leave old records behind not much to get.

As a quick'n'dirty solution in the past I had reports scheduled and emailed with current state. Then once in a while I would go through them and create my own trending. However, that's basically just the manual process that PA automates.

[Amarjeet Pal]

Hello @Tom104 ,

If you need a trend report we can go with performance analytics.

Creation of indicator source, automated indicators, create a job and then display it on the dashboard create a widget.

Important: Automated Indicators: These are essentially the questions you want answered by your data. You will need to create one for 'Quantity of Headsets' and configure it so that it calculates the sum of all headsets.

Thanks

[Tom104]

Thanks for this, I've been granted access to analytics, and have set up a spline to show the quantity of the model over time, however I've now been asked to do this for every Model we have in the stockroom.

Do you happen to know how I'd go about creating this? Ideally, I'd want a single spline graph with one spline for each model, model names displayed in the x axis key, and the quantity as the data point on a weekly basis.

I don't seem to be able to put a "Count distinct" against the model name AND have the quantity data points show while keeping the names of the models in the X-Axis key.