dast04
1
Hi everyone,
I have the following setup:
In here I am creating tables to determine if pod has been in status of “Evicted” or “Error”
I then use transformations as follows;
- Merge series/tables
- Organize fields by name
And then my table looks like this"
My goal
At the end I want to have 3 columns. namespace, pod, and reason.
The reason will have value of “Evicted” or “Error”
Any help is much appreciated!
P.S.
I chose this approach but if you know a better way, I am open for suggestions
it takes a couple of steps…
step1:
convert data to numeric
step2:
multiply the evicted field by -1, to differentiate between error and evicted as positive or negative:
step 3:
multiply the error field by 1:
step 4:
add the results from the previous two operations together and alias it:
that should give a 1 for error and a -1 for evicted
step 5:
then add a value mapping on the alias for 1 and -1 and hide the other fields
1 Like
dast04
3
The best!
Thank you very much - much appreciated
1 Like
