topic Re: Dashboard in Dashboards & Visualizations

How to create a Dashboard?

revanthammineni — Wed, 22 Mar 2023 20:28:24 GMT

Hi Splunkers,

I’m working on a Dashboard panel where I have to create a monthly wise data as shown in the screenshot.
I have a field called “age group” and corresponding month’s data. But every month’s data comes from an external lookup file.

Data for example:

Age Group Sept July Jun

30-90 235 0 34

90-180 1757 2168 3467

180+ 19374 20,534 12,661
I’m using this below code but it’s not actually working for me. Please help me with the logic to produce the chart like as it was in the screenshot. TIA

…

|chart count by _time, “Age Group”

Re: Dashboard

ITWhisperer — Wed, 22 Mar 2023 06:26:58 GMT

There are mixed messages in your requirement - the example table you have shown gives the first column as age groups with dates as the subsequent columns, whereas the SPL and the screenshot would be give the first column as dates and subsequent columns as age groups.

For the first table, try this:

For the screenshot, try this:

Re: Dashboard

revanthammineni — Wed, 22 Mar 2023 06:31:06 GMT

yeah, I’m trying to achieve the screen shot. But the you’ve mentioned isn’t working unfortunately.

Re: Dashboard

ITWhisperer — Wed, 22 Mar 2023 06:32:56 GMT

In what way is it not working?

Re: Dashboard

revanthammineni — Wed, 22 Mar 2023 06:51:53 GMT

returning all 1’s in the statistics

Re: Dashboard

ITWhisperer — Wed, 22 Mar 2023 06:59:57 GMT

OK, it sounds like your actual data already has the counts in?

This means that your example search would also have returned 1's

Try summing the counts (assuming the count column in your csv is called "count")

It is often helpful and less time-consuming if you provide as much information about your problem as possible so we are not left guessing and end up providing incorrect solutions based on false assumptions.