Just search your data over a month period and calculate your statistics.
But seriously - we have no way of knowing what data you have in your Splunk environment, what do "TPS" or "route codes" mean in this context and what is it you want to get (especially that you're saying about some TPS parameter which suggests "something per second"; most probably transactions of some kind) but then talk about count - how would you want to "match' those TPS to count of something else?
Provide some sample (anonymized if needed) data you have, be more precise about what you want to achieve (possibly including mockup results) and we can try to think about your problem.
