topic Re: Help how to create bar chart from two different source? in Dashboards & Visualizations

Help how to create bar chart from two different source?

dhavamanis — Mon, 28 Sep 2020 18:02:51 GMT

Need a help.

Can you please provide the sample query to draw the bar chart (stacked bar chart) with the below info. We have the two sources and index="idxstaging"

/var/log/idx/dispacher.log
column:
transaction_id
worker_time (number)
database_time (number)
/var/log/idx/api.log

Column:
transaction_id
api_response_time (number)

how can i build a bar chart based on transaction_id from the above column. We want to show the each transaction how long time its spent for worker_time, database_time and api_response_time.

Re: Help how to create bar chart from two different source?

martin_mueller — Thu, 30 Oct 2014 18:30:26 GMT

Try this:

index=idxstaging (source=/var/log/idx/dispacher.log OR source=/var/log/idx/api.log) | chart sum(worker_time) sum(database_time) sum(api_response_time) by transaction_id

Configure the chart to bar and stacked through the UI.

Re: Help how to create bar chart from two different source?

dhavamanis — Thu, 30 Oct 2014 18:50:36 GMT

It works, Thank you so much, how can i order the results based value in the chart. like highest value on top and lowest value to bottom.

Re: Help how to create bar chart from two different source?

martin_mueller — Thu, 30 Oct 2014 18:53:19 GMT

Append this to your search:

... | addtotals | sort - Total | fields - Total

Re: Help how to create bar chart from two different source?

dhavamanis — Mon, 28 Sep 2020 17:58:35 GMT

Thank you, is it possible to show in this order from the bottom, api_response_time, worker_time and database_time (o top). because the database values are very less and not showing any results.

Re: Help how to create bar chart from two different source?

martin_mueller — Thu, 30 Oct 2014 19:42:15 GMT

I'm pretty sure that order is based on the column names alphabetically, so name them in a way that suits your ordering needs.