topic Re: trellis chart showing the average time spent on a website in Dashboards & Visualizations

How to plot a trellis chart showing the average time spent on a website?

splunkis0927 — Thu, 07 Jul 2022 14:06:16 GMT

Hi Community,

If i need Plot a trellis chart showing the average time spent on a website for each user session by browser

what's the best approach for this ?

Re: trellis chart showing the average time spent on a website

gcusello — Wed, 06 Jul 2022 06:40:08 GMT

everything in Splunk is a search, so you have to create a search to have the result that you need, then you can choose the way to show your results (e.g. Trellis).

At first you have to find the results to aggregate and then aggregate them using some stremeing command like stats, something like this:

index=your_index sourcetype=your_sourcetype | stats count BY session_id

when you have the results as a table, you can use the gui fetures of Splunk to choose the chart you like and the Trellis.

But As I said, Trellins and chart type is a secondary issue: secondary for importance and scheduling.

Ciao.

Giuseppe

Re: trellis chart showing the average time spent on a website

splunkis0927 — Wed, 06 Jul 2022 07:02:35 GMT

thanks for the help. here is the output I am going to try, but atm i am not sure how to aggregate these browsers in a table

Re: trellis chart showing the average time spent on a website

gcusello — Wed, 06 Jul 2022 07:57:51 GMT

Hi @splunkis0927,

the search you used is without sense!

you have to choose to use transaction ( I use it only when I don't have any other solution because it's a very slow command!) or stats.

In addition, you could also use timechart but only if you have one field for grouping (e.g. only JSESSIONID or clientip).

Then if you use _time in stats, you have also to use bin otherwise in this way you have groups that differs for a second.

try something like this:

index=main "http://www.buttercupgames" | bin span=1h _time | stats count BY SESSIONID clientip _time

Ciao.

Giuseppe

Re: trellis chart showing the average time spent on a website

splunkis0927 — Wed, 06 Jul 2022 14:25:47 GMT

Thank you so much !!

I think I have the data now, but not sure how to Plot a trellis chart showing the average time for
each user session by browser