Hello everyone!
I would like to know the percentage of growth of the field "wasted_MB" day by day, that is, the percentage of growth compared with the 27 on 26, 26 on 25, 25 to 24, 24 to 23 and so on...
Here is a brief sample of the data I have been analyzing:
TABLE actual_MB size_MB wasted_MB _time
TK_LOGON 458.83 615.72 156.89 27/04/2015 18:22
TK_LOGON 454.19 615.72 161.53 26/04/2015 18:22
TK_LOGON 496.77 615.72 118.95 25/04/2015 18:22
TK_LOGON 481.16 615.72 134.56 24/04/2015 18:22
TK_LOGON 482.07 615.72 133.65 23/04/2015 18:22
Today only can do the comparison between two values, for example:
- Today's values with those of yesterday.
- The values of this week with the week of values passes.
Follows search used to compare the present day with the previous day:
index=data_base sourcetype=size_table_frag earliest=-2d@d latest=@d TABLE=TK_LOGON | stats first(wasted_MB) AS current, last(wasted_MB) AS previous by TABLE | eval per_grown = (current/previous -1)*100 | stats values(per_grown) AS per_grown, values(previous) AS previous, values(current) AS current by TABLE
Follow the result I can with this search:
TABLE per_grown previous current
TK_LOGON -2.873 161.53 156.89
However, I would calculate the percentage day to day according to the time when I determine. So it could put the evolution of growth in a "timechart".
I hope I was clear in the description of the problem.
Now grateful for the support.
Sincerely.
... View more