Activity Feed
- Posted Re: Use eval (or other) to make automatic calculation in xyseries on Splunk Search. 03-08-2021 08:29 AM
- Tagged Re: Use eval (or other) to make automatic calculation in xyseries on Splunk Search. 03-08-2021 08:29 AM
- Tagged Re: Use eval (or other) to make automatic calculation in xyseries on Splunk Search. 03-08-2021 08:29 AM
- Tagged Re: Use eval (or other) to make automatic calculation in xyseries on Splunk Search. 03-08-2021 08:29 AM
- Tagged Re: Use eval (or other) to make automatic calculation in xyseries on Splunk Search. 03-08-2021 08:29 AM
- Posted Re: Use eval (or other) to make automatic calculation in xyseries on Splunk Search. 03-03-2021 12:54 AM
- Tagged Re: Use eval (or other) to make automatic calculation in xyseries on Splunk Search. 03-03-2021 12:54 AM
- Posted Use eval (or other) to make automatic calculation in xyseries on Splunk Search. 02-22-2021 01:02 PM
Topics I've Started
| Subject | Karma | Author | Latest Post |
|---|---|---|---|
| 0 |
03-08-2021
08:29 AM
Thanks for all! Finally, how can I change order based on the most recent date and number (2021-01-20, descending) and also change the cell color based on the value? Ex: -> If the cell value is bigger than 5, puts cell color red, If cell color is between 0 and 5, puts orange, if is less than 0, puts green. -> 2021-01-20 31 25 13 5 ################################################################# The goal! 2021-01-19 2021-01-20 Dif_19_20 Item 1 29 31 -2 (31-29) (Green) Item 2 37 25 -12 (25-37) (Green) Item 4 10 13 3 (13-10) (Red) Item 3 8 5 -3 (5-8) (Green)
... View more
03-03-2021
12:54 AM
Hi again, this as done the work...and just another question, if I have several dates, how can I show only the last two and the difference? ex: 2021-01-19 2021-01-20 Dif_19_20 Item 1 29 31 -2 (31-29) Item 2 37 25 -12 (25-37) Item 3 8 5 -3 (5-8) Item 4 10 13 3 (13-10) Thanks in advance and sorry for the delay in answer.
... View more
- Tags:
- hi
02-22-2021
01:02 PM
Hi, I have an automatic process that daily writes some information in a CSV file [1]. Then I have a dashboard that picks up some data and uses xyseries so that I can see the evolution by day. [2] Now I want to calculate the difference between everyday, but the problem is that I don't have "field" names so that I can use in an Eval, so I can I solve this? [3] Please see examples below. ################################################ [1] Information Saved every day [ | is the separator of each column] [Item_Name] | [Date_1] | [Total] 2021-01-18 Item 1 | |2021-01-18 | 32 Item 2 | |2021-01-18 | 50 Item 3 | |2021-01-18 | 10 Item 4 | |2021-01-18 | 15 2021-01-19 Item 1 | |2021-01-18 | 29 Item 2 | |2021-01-18 | 37 Item 3 | |2021-01-18 | 8 Item 4 | |2021-01-18 | 10 2021-01-20 Item 1 | |2021-01-20 | 31 Item 2 | |2021-01-20 | 25 Item 3 | |2021-01-20 | 5 Item 4 | |2021-01-20 | 13 ################################################ | inputlookup blabla | xyseries Item_Name Date_1 Total [2] Applying xyseries I get the following 2021-01-18 2021-01-19 2021-01-20 Item 1 32 29 31 Item 2 50 37 25 Item 3 10 8 5 Item 4 15 10 13 ################################################ [3] What I would like to have 2021-01-18 2021-01-19 2021-01-20 Dif_18_19 Dif_19_20 Item 1 32 29 31 -3 (29-32) 2 (31-29) Item 2 50 37 25 -13 (37-50) -12 (25-37) Item 3 10 8 5 -2 (8-10) -3 (5-8) Item 4 15 10 13 -5 (10-15) 3 (13-10) ################################################ Thanks in advance. Best Regards,
... View more
Labels
- Labels:
-
eval
