I want to visualize TPS(Transaction per second) in Kibana. I am trying to visualize it using TSVB(Time Series Visual Builder) . What i am currently doing is in Guage panel options in Data time range mode i have selected last value option value and in interval i have entered 15 mins time interval to get data in last 15 mins time interval. In Data Panel what i am doing is performing count aggregation and on that aggregation i am performing Bucket Script and dividing the count by 900 in case of 15 mins. Is this a good approach which i am following or there is some other approach to Visualize these kind of situation. Sharing screenshots of what i have done.
Posting some sample data maybe useful: