How to map sorted values on x-axis to integers

[Aditya_V]

For instance, if I have a set of dates on X-axis starting from June-1-2018 to July-3-2018, I want instead to show the values from 1 - 32

The actual usecase is as follows - I want to use Split Series feature to compare data sets from two different date ranges, on top of each other

Say I have a curve X for all dates, and I want to superimpose curve X at month of June on top of curve X at month of September, how can I do it using a Visualization? (I figured a split-series combined with above mapping should achieve it, but I don't know how to achieve the mapping)

[LeeDr (Lee Drengenberg)]

The easiest way would be to use either Timelion or the Visual Builder for this.

Here's one post where a user is doing the offset in Timelion;

Timelion and ISO Week

Hi there, I would like to compare two weeks with: .es(index=my-index, metric="sum:sessions").label('past week'), .es(index=my-index, metric="sum:sessions", offset=-1w).label('prev week') At the moment with offset=-1w I get one day more then expected and after that every day duplicated in the timeline (x-axis) so how do I tell Kibana that I want to get an iso week?

And a tutorial here which includes offset time;

Getting Started with Time Series Analysis in Kibana

And here's some info on the Time Series Visual Builder which can also do offsets;

Kibana Time Series Visual Builder

Regards,
Lee

[Aditya_V]

Thanks for the response!

I'm wondering if it's possible as part of a shared dashboard/visualization

[LeeDr (Lee Drengenberg)]

Yes, Timelion and the Visual Builder both save Visualizations that can be shared or used in Dashboards.