topic Re: Update kvstore in Knowledge Management

Update kvstore

javier_reina — Tue, 11 May 2021 07:49:50 GMT

Good morning,

We are trying to use a kvstore to store data when performing a query to later query it in a dashboard.

The kvstore has the following data:

Subcontrols | Value1 | Value2
1.1 | 100 | 99
1.2 | 200 | 80
1.3 |99 | 98

Reviewing the documentation and following the examples we can enter a number manually in the query and change the value using a | eval :

And the result would be the following:

Subcontrols | Value1 | Value2
1.1 | 100 | 526
1.2 | 200 | 80
1.3 |99 | 98

The problem appears when we try to update the Value2 field of a Subcontrol from another query:

EX:

The result in the kvstore would be the following:

Subcontrols | Value1 | Value2
1.1 | 100 | 526
1.2 | 200 | 80
1.3 |99 | 98
| 396

Could someone help me and tell me how to correctly perform the query so that from another query I can write the Value2 field of a specific Subcontrol please?

Thank you very much in advance,

Re: Update kvstore

kamlesh_vaghela — Tue, 11 May 2021 08:58:20 GMT

@javier_reina

Can you please try this?

Re: Update kvstore

javier_reina — Fri, 04 Jun 2021 07:32:39 GMT

Good morning @kamlesh_vaghela

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

Do you 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.

Re: Update kvstore

kamlesh_vaghela — Fri, 04 Jun 2021 08:04:06 GMT

@javier_reina

Have you tried eval ?

| eval percentage = round((value1/value2)*100)