topic Re: How can I do calculations like Excel row data in Dashboards & Visualizations

How to create search do calculations and make it like Excel row data?

FcwfCW76 — Thu, 10 Feb 2022 14:31:20 GMT

Hi, all!
I have a table

I want to be like this

How can I do this?
Can help me?

ITWhisperer — Wed, 09 Feb 2022 15:51:58 GMT

| transpose 0 header_field=name column_name=name | eval C=(A*2)+B | eval D=(A*2)+(B*2) | transpose 0 header_field=name column_name=name

Where name is the name of the first column

FcwfCW76 — Thu, 10 Feb 2022 01:16:28 GMT

@ITWhisperer Thank you so much

But the columns that is not a number is null, is it can to join at the same time?

ITWhisperer — Thu, 10 Feb 2022 06:48:00 GMT

Do you mean you don't have the first column of your table in splunk?

If so, you can add a field (column) to each row before the transpose

FcwfCW76 — Thu, 10 Feb 2022 09:06:50 GMT

@ITWhisperer Sorry I can't express clearly

I want this

but now is this

Thanks again for your help

ITWhisperer — Thu, 10 Feb 2022 10:14:07 GMT

FcwfCW76 — Fri, 11 Feb 2022 03:36:59 GMT

Thank you so much

but I still have a lot of questions

Can you give me your contact information?

FcwfCW76 — Fri, 11 Feb 2022 04:59:28 GMT

Thank you