Compare 2 calculated values in a chart

[Declan123]

Hi All,

I am trying to calculate 2 values by multiplication and then compare these 2 values on a column/bar chart. 

My query to calculate the 2 values is:

source="transaction file.csv" Description="VDP-WWW.AMAZON" | rename "Debit Amount" AS DebitAmount | eval totalprime=DebitAmount*59 | eval totalvalue=286*5.99

However I am having trouble displaying them on a chart to compare their values. I would ideally like them to both be on the X axis and have the Y axis as a generic 'total value' or similar just so I can easily see how one value compares against the other. 

When I attempt to do this with a query like the below,  I have to select 1 field as X axis and 1 as Y axis which leads the chart being incorrect. 

source="transaction file.csv" Description="VDP-WWW.AMAZON" | rename "Debit Amount" AS DebitAmount | eval totalprime=DebitAmount*59 | eval totalvalue=286*5.99 | chart sum(totalprime) as prime, sum(totalvalue) as value

I want totalvalue as a column and totalprime as another column, next to each other. To allow me to easily compare the total amount of each next to each other. 

Can anyone help with this? Thanks.

[gcusello · Accepted solution]

Hi @Declan123 ,

did you trid the transpose command?

try something like this:

source="transaction file.csv" Description="VDP-WWW.AMAZON" 
| rename "Debit Amount" AS DebitAmount
| eval totalprime=DebitAmount*59 
| eval totalvalue=286*5.99
| stats sum(totalprime) AS totalprime sum(totalvalue) AS totalvalue
| transpose

you'll have something like this:

Ciao.

Giuseppe

[Declan123]

Thank you Giuseppe, that was exactly what I was looking to achieve.