I am trying to create a pareto chart. I have already done that portion of the work. I have been asked to identify a number of items in a specific page range as a part of the task. I did that, but I have been asked to find a way to identify the average time taken to process the number of items. To get a better understanding to say for example I have 736 items in 3 pages.
What function would I use to identify the amount of time per item?
Hopefully, that provides a better way to see what I am getting at.
Any input would be appreciated. Thank you in advance.
This is what I have so far this is not everything but the portion of the work I was mentioning above:
| eval overallTime=elapsedTime/1000
| eval processTimePerItem=overallTime/totalItems
| streamstats sum(processTimePerItem) as processTimePerITem by pageCount