topic Re: How to remove a field from visualisation? in Dashboards & Visualizations

How to remove a field from visualisation?

zacksoft — Tue, 29 Sep 2020 19:15:26 GMT

I intended to check the rate of change of my response time of http requets, for which I use the delta command.
Here is how it goes,

| base query
| timechart span=30s avg(Response_Time) as Response_Time| delta Response_Time as rate_of_change

Now, when it runs, I go to visualiatization and select line chart. It gives me two lines 1. Response_Time 2. rate_of_change.
I don't want response_time , I only want the visualization to show 'rate_of _change'

Re: How to remove a field from visualisation?

TISKAR — Thu, 26 Apr 2018 08:16:14 GMT

Hello can you try this please:

| base query
| timechart span=30s avg(Response_Time) as Response_Time| delta Response_Time as rate_of_change | fields - Response_Time

Re: How to remove a field from visualisation?

zacksoft — Tue, 29 Sep 2020 19:15:32 GMT

cool ! This helps. If I may ask one related question. Instead of evaluating delta of average Response_Time, if I want to calculate delta only of response_time, what change I do? I tried values(Response_Time) it won't work. Thank you.

Re: How to remove a field from visualisation?

TISKAR — Thu, 26 Apr 2018 08:32:36 GMT

Try by this:

| base query
     | delta Response_Time as rate_of_change | table rate_of_change , _time

Can you accept the answer to help another person please

Re: How to remove a field from visualisation?

TISKAR — Thu, 26 Apr 2018 08:32:45 GMT

Can you accept the answer to help another person please

Re: How to remove a field from visualisation?

zacksoft — Thu, 26 Apr 2018 08:36:35 GMT

But I seek to find the delta between now and the response time after 15 seconds. .
The above command evaluates Delta between consecutive response time...!!!

Re: How to remove a field from visualisation?

TISKAR — Thu, 26 Apr 2018 08:43:35 GMT

Use that:

| base query
| bin _time span=15s
| delta Response_Time as rate_of_change | table rate_of_change , _time

Re: How to remove a field from visualisation?

zacksoft — Tue, 29 Sep 2020 19:15:41 GMT

The only change I made to your suggestion is, I removed _time from | table and kept rate_of_change only , but somehow the visualizations won't work. (line chart)

Re: How to remove a field from visualisation?

TISKAR — Tue, 29 Sep 2020 19:15:46 GMT

If you want a graphic represent variation rate_of_change by _time you must keep the _time, because if you remove _time you have one field, and line chart represent the variation between two field