How to remove a field from visualisation?

[zacksoft]

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'

[TISKAR · Accepted solution]

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

[zacksoft]

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.

[TISKAR]

Can you accept the answer to help another person please

[TISKAR]

Use that:

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

[zacksoft]

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)

[TISKAR]

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

[TISKAR]

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

[zacksoft]

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...!!!