topic Re: How to achieve correct chart visualization & overlay? in Dashboards & Visualizations

How to achieve correct chart visualization & overlay?

Manasa_401 — Fri, 16 Dec 2022 14:04:43 GMT

Hello Splunkers

Need your help to get the desired result.
Below is the sample query for reference.

But since values() is used we are getting target fields for each week. But expected outcome is to get one each line for target1 & target2.

Please help me to get the visualization in correct format.

Thanks in advance!!

Re: How to achieve correct chart visualization & overlay?

ITWhisperer — Fri, 16 Dec 2022 14:41:56 GMT

It is not clear what you expect the chart to look like

Having said that, does this help:

|chart last(final) as final values(target1) as target1 values(target2) as target2 over week_year by group

Re: How to achieve correct chart visualization & overlay?

Manasa_401 — Fri, 16 Dec 2022 14:53:51 GMT

Hello @ITWhisperer

If you run till the table command you will get the results as shown below.

my required visualization is to show data in below similar format, but instead of 4 lines i just need one each line for both targets.
I need help on the query to get desired format.

Re: How to achieve correct chart visualization & overlay?

ITWhisperer — Fri, 16 Dec 2022 15:03:46 GMT

Given your sample data, what points do you want shown on the two lines?

Re: How to achieve correct chart visualization & overlay?

Manasa_401 — Fri, 16 Dec 2022 15:21:39 GMT

I need target1 and target2 values to be shown as line

Re: How to achieve correct chart visualization & overlay?

ITWhisperer — Fri, 16 Dec 2022 15:26:25 GMT

Which value do you want for target1 for ABC and which value do you want for target1 for XYZ? You have two possible values given the data you presented - that's why you have more lines than you were expecting; the lines are doubled up because you have two year-weeks