topic Two y Axis in Dashboards & Visualizations

Two y Axis

corematrix — Wed, 18 Jul 2018 20:27:56 GMT

I have a very simple index which tracks a competitive game. Over the course of the year, people earn points for the top 16 positions switch places. In a CSV I track their Name, rank, score at regular intervals.

Below is a screenshot of my data in a simple table and an example of the kinda of the graph I wish to build.

How would I go about making this?

Name on the right > < Rank on the left
> time along the bottom <

Re: Two y Axis

renjith_nair — Thu, 19 Jul 2018 05:40:19 GMT

@corematrix ,

Does this work for you ?

index=cptracker|timechart latest(global_rank) as global_rank by screen_name

 index=cptracker|chart latest(global_rank) as global_rank over _time by screen_name

Re: Two y Axis

corematrix — Thu, 19 Jul 2018 14:04:46 GMT

Thanks for your idea but it doesn't quite work. Each row appears to only be relevant to it'self, want the x axis to be fixed and the lines to track across the x axis.

How would i sorted it so that the global_rank is in order?

Re: Two y Axis

renjith_nair — Sat, 21 Jul 2018 04:43:43 GMT

@corematrix, have you selected "Multi-series Mode" on? In that case, each line uses its own series and there wont be any overlap