topic Re: Calculate percentage between two different panels in Dashboards & Visualizations

Calculate percentage between two different panels

sobotiv — Wed, 26 May 2021 09:30:29 GMT

I have a dashboard setup like this.

First panel shows statistics by categories, and you can choose a time interval to display the data. Search code is: index=kopo sourcetype="kopo primjeri" category1 |top limit=20 category1. Time range scope is set with the drop down menu above the table, named time_prev

Second panel basically does the same thing, again you can choose the time interval. Search code is: index=kopo sourcetype="kopo primjeri" category1 |top limit=20 category1. Time range scope is set with the drop down menu above the table, named time_curr

What I'm trying to do is, in the third panel, show percentage difference between the second panel count and first panel count.

Re: Calculate percentage between two different panels

gcusello — Wed, 26 May 2021 12:15:39 GMT

Hi @sobotiv,

in the third panel you have to use both the searches and calculate and display percentages, but the question is: are you sure that the first 20 results (top 20) of the first panel will be the same of second and third panel?

To do this I hint to create only one search with the contents of all panels and then display in each panel the relative field.

Obviously running the same search in three panels you have to use the Post Process Search.

Ciao.

Giuseppe

Re: Calculate percentage between two different panels

sobotiv — Thu, 27 May 2021 07:39:03 GMT

Hey,

yes, the amount of results is always the same