Display data on single bar line in chart

[rvisj]

I have some records in csv, each record has a column 'payment method'. I have to count by 'payment method' and the result should how in single line in chart
Each color in chart represents a payment method

[woodcock]

Like this:

Your Base Search Here | eval label="Payment Methods" | contingency label "payment method" | search label!="TOTAL"

Set the visualization to Bar Chart and set the Stack Mode to the one on the right (stacked).

[rvisj]

thanks for your reply. I tried this but 'Total' is coming as a payment method and adding up in the chart

[woodcock]

Also add | fields - Total TOTAL to the end.

[adonio · Accepted solution]

hello @rvisj
here i user an Instrumental Variable (... | eval var=1 )to use the chart command for the visualization you requested
in screenshot 1 you will see the lookup i created.
screenshot 2 has the search i used and bar chart
heres the search: | inputlookup payments.csv | eval var=1 | chart count(record) over var by payment_method
hope it helps

[rvisj]

Working..thanks @adonio. Can we remover that 'var 1' label from Y-axis