topic Re: How can I remove ONLY the overlay Total on a visualization? in Splunk Search

How can I remove ONLY the overlay Total on a visualization?

ashidhingra — Thu, 19 Sep 2024 14:58:58 GMT

How can I remove ONLY the overlay Total on a visualization? TIA

Re: How can I remove ONLY the overlay Total on a visualization?

dural_yyz — Thu, 19 Sep 2024 15:05:42 GMT

What is your search string behind the viz? It could be as simple as appending the search with...

| fields - overlay_field_name

Re: How can I remove ONLY the overlay Total on a visualization?

ashidhingra — Thu, 19 Sep 2024 21:03:55 GMT

index= | bucket span=1s _time | stats count by _time | timechart max(count) AS Peak_TPS span=1d | eval overlay=10

I want to remove the number display on overlay

Re: How can I remove ONLY the overlay Total on a visualization?

dural_yyz — Thu, 19 Sep 2024 18:09:56 GMT

This is confusing because your search specifically sets the values you want to remove. Simple solution is to remove the last pipe and eval of the additional field. Assuming you need that for some alternate reason then I would recommend.

1) Create base search "ds_base" don't include the pipe and eval of the overlay

2) Create the viz and map the data source to the base search

3) Create a chain search which has the pipe and eval of the overlay field and map it to the base

4) Map the alternate need to the chain search as the source

Re: How can I remove ONLY the overlay Total on a visualization?

ashidhingra — Thu, 19 Sep 2024 18:11:23 GMT

I dont want to remove the overlay. I only want to remove the number 10.

Re: How can I remove ONLY the overlay Total on a visualization?

ashidhingra — Thu, 19 Sep 2024 18:12:32 GMT

Re: How can I remove ONLY the overlay Total on a visualization?

ITWhisperer — Fri, 20 Sep 2024 07:55:59 GMT

If you are using Classic/SimpleXML dashboards, you can do this with CSS.

For this you need to give your panel an id (so it gets tagged so CSS can select it), then you need to know the order of the series in the charts and they are numbered. For example, if you name your panel "panel_one", and your Total was the second series (index 1), you could do something like this

<panel id="panel_one"> <html depends="$alwaysHide$"> <style> #panel_one svg g.highcharts-data-labels.highcharts-series-1 { display: none !important; } </style> </html> <chart>

Re: How can I remove ONLY the overlay Total on a visualization?

dural_yyz — Fri, 20 Sep 2024 13:03:22 GMT

When using dashboard studio currently there is no option for this.

dataValuesDisplay

("off" | "all" | "minmax")

off

Specify whether chart should display no labels, all labels, or only the min and max labels.

https://docs.splunk.com/Documentation/SplunkCloud/9.2.2406/DashStudio/chartsBar

I have even tried putting the overlay into the y2 axis and the dataValuesDisplay is a higher level option so impacts all axis.

{
    "type": "splunk.column",
    "dataSources": {
        "primary": "ds_TNxdC2O9"
    },
    "containerOptions": {},
    "showProgressBar": false,
    "showLastUpdated": false,
    "title": "Column Chart",
    "description": "Overlay Test",
    "options": {
        "y": "> primary | frameBySeriesNames('regular','_span')",
        "y2": "> primary | frameBySeriesNames('overlay','_span')",
        "overlayFields": [
            "overlay"
        ],
        "dataValuesDisplay": "all"
    },
    "context": {}
}

Re: How can I remove ONLY the overlay Total on a visualization?

ITWhisperer — Fri, 20 Sep 2024 13:31:54 GMT

Yes, Studio is not a good choice for anything vaguely sophisticated!