topic Re: How do you create a line graph which shows 3 values? in Dashboards & Visualizations

How do you create a line graph which shows 3 values?

QuintonS — Fri, 19 Oct 2018 13:22:45 GMT

Rookie Question: I am trying to create a line graph showing 3 values. i have the query which works perfectly to show "ratings" per site for each site per week. But i want to show the overall rating for both sites as well.

here is the query i use..

| eval week=relative_time(_time,"@w1")
| eval week=strftime(week,"%V")
| chart avg(overall_rating) over week by area

area= field name and contains values for 2 sites. if i remove "by area" then i get the overall rating for both sites and i want to get that showing in the same graph.

please help a newbie!! 🙂

Re: How do you create a line graph which shows 3 values?

renjith_nair — Fri, 19 Oct 2018 14:27:38 GMT

@QuintonS,

If are looking for just total over week then, try

| eval week=relative_time(_time,"@w1")
| eval week=strftime(week,"%V")
| chart avg(overall_rating) over week by area
| addtotals

Updated:

  | eval week=relative_time(_time,"@w1")
  | eval week=strftime(week,"%V")
  | eventstats avg(overall_rating) as OVERALL_RATING
  | chart avg(overall_rating),max(OVERALL_RATING) as OVERALL_RATING over week by area
  | rename "avg(overall_rating): *" as *,"OVERALL_RATING : *" as DEL*|foreach DEL*[eval OVERALL_RATING =<<FIELD>>]|fields - DEL*

Re: How do you create a line graph which shows 3 values?

QuintonS — Fri, 19 Oct 2018 14:35:09 GMT

Hi Renjith, not looking for the totals.

output i want should look like the following.

Week, Site1, Site2, Overall rating

hope this makes sens?

Re: How do you create a line graph which shows 3 values?

renjith_nair — Tue, 29 Sep 2020 21:43:13 GMT

So is it not Site1_Rating+Site2_Rating? May be a sample data will be helpful. Sorry for that.

Re: How do you create a line graph which shows 3 values?

QuintonS — Fri, 19 Oct 2018 14:49:57 GMT

i need to provide average of ratings for the client. so i have daily data with a "overal_rating" field. and i also have data per site. So i need to show average overall rating and average overall rating per site in the same graph. cant share sample data unfortunatley..

Re: How do you create a line graph which shows 3 values?

renjith_nair — Fri, 19 Oct 2018 15:14:45 GMT

Okie, calculate this value before chart and add it in chart

 | eval week=relative_time(_time,"@w1")
 | eval week=strftime(week,"%V")
 | eventstats avg(overall_rating) as OVERALL_RATING
 | chart avg(overall_rating),max(OVERALL_RATING) as OVERALL_RATING over week by area

Re: How do you create a line graph which shows 3 values?

renjith_nair — Fri, 19 Oct 2018 15:16:53 GMT

Added little clean up 🙂

    |rename "avg(overall_rating): *" as *,"OVERALL_RATING : *" as DEL*|foreach DEL*[eval OVERALL_RATING =<<FIELD>>]|fields - DEL*

Re: How do you create a line graph which shows 3 values?

QuintonS — Fri, 19 Oct 2018 15:32:12 GMT

This is very close, need to do some tweeks. seems to be working.

Thanks so much for the help! 🙂

Re: How do you create a line graph which shows 3 values?

renjith_nair — Fri, 19 Oct 2018 16:05:41 GMT

You are welcome @QuintonS,. Updated the answer, please accept if it's ok