Good morning
In a kv store we have 3 columns: Subcontrol, Value1 and Value2.
We are trying to calculate the percentage of Value1 and Value2 for each of the rows with a | eval and that creates new fields with the percentage, for example:
Expected result:
Subcontrol1%=0
Subcontrol2%=0
Subcontrol3%=100
Does anyone know how to perform the query to get the percentages in a new field for each row?
Greetings and thank you very much in advance.
