About JeffV

JeffV

Hi Kiran, Thanks for the info. I did post my solution earlier today. And, I think it pretty much mirrors what you've got. So, at least I know I am on the right wavelength.

JeffV

Ended up going with this that works pretty good. [My Search] | timechart span=$span$d dc(userSesnId) as count_of_user_sessions | trendline sma$sma$(count_of_user_sessions) as "Moving Average" | rename count_of_user_sessions AS "Disctinct Count of User Sessions"

JeffV

I've got to be close. But having issues trying to figure out how to get a distinct count of user sessions to show up in a bar chart with a trendline. I'd like to see a distinct count of users for last year by month and have a trendline added. <My Search> | stats dc(userSesnId) as moving_avg | timechart span=30d dc(userSesnId) as count_of_user_sessions | trendline sma4(moving_avg) as "Moving Average" | rename count_of_user_sessions AS "Disctinct Count of User Sessions"

JeffV · ‎09-11-2024

I think I got it. | timechart span=1h perc85(time_taken) by cs_uri_stem

JeffV · ‎09-11-2024

Sorry, I wasn't clear. I only need to add the URI_Stem (which is the URL of the API from IIS) to the timechart shown in the first query. I want to track time_taken (performance of the calls to different APIs our app is making) over time so I can see outlier periods. Hopefully this is clearer.

JeffV · ‎09-11-2024

I have a timechart that traffic volume over time and the top 15% of API performance times. I would like to add URI_Stem to the timechart so that I can track performance over time for each of my API calls. Not sure how that can be done. | timechart span=1h count(_raw) as "Traffic Volume", perc85(time_taken) as "85% Longest Time Taken" Example of table by URI_Stem | stats count avg(time_taken) as Average BY cs_uri_stem | eval Average = round(Average, 2) | table cs_uri_stem count Average | sort -Average | rename Average as "Average Response Time in ms"

Posts	6
Solutions	1
Karma Given	2
Karma Received	1
Member Since	‎09-11-2024

Online Status	Offline
Date Last Visited	Tuesday

Apply a trendline to a chart of Unique User Sessio...

Adding IIS URI_Stem to timechart to track performa...

Re: Apply a trendline to a chart of Unique User Se...

Re: Apply a trendline to a chart of Unique User Se...

Apply a trendline to a chart of Unique User Sessio...

Re: Adding IIS URI_Stem to timechart to track perf...

Re: Adding IIS URI_Stem to timechart to track perf...

Adding IIS URI_Stem to timechart to track performa...