Two y Axis

[corematrix]

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 <

[corematrix]

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?

[renjith_nair]

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

[renjith_nair]

@corematrix ,

Does this work for you ?

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

or

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