Hi ! I am trying to modify the legend generated by the timewrap command. I saw that we could slightly change it with the parameter "series" but it's not really giving me what I want.
Let's say I want to have a sum of prices from this request :
index=sandbox earliest=-13d | timechart sum(prices) as "Sum of the prices" span=d | timewrap 1w series=relative
The legend will be Sum of the prices_1week_before
and Sum of the prices_latest_week
. I would like to have something like Sum of the prices for the week before
and Sum of the prices for the latest week
.
How can I get this ? Thanks !
One option would be to use series="exact"
option to provide format for time series i.e.
<yourCurrentSearch>
| timewrap 1w series=exact time_format="Sum of the prices for %Y-%U week"
If you intend to use series="relative"
, you can use rename command to change series name as required (relative option will generate some generic names as per the series name in the timechart.
<yourCurrentSearch>
| timewrap 1w series=relative
| rename "Sum of the prices_latest_week" as "Sum of the prices latest week",
"Sum of the prices_1week_before" as "Sum of the prices the week before",
One option would be to use series="exact"
option to provide format for time series i.e.
<yourCurrentSearch>
| timewrap 1w series=exact time_format="Sum of the prices for %Y-%U week"
If you intend to use series="relative"
, you can use rename command to change series name as required (relative option will generate some generic names as per the series name in the timechart.
<yourCurrentSearch>
| timewrap 1w series=relative
| rename "Sum of the prices_latest_week" as "Sum of the prices latest week",
"Sum of the prices_1week_before" as "Sum of the prices the week before",
That's perfect, thank you 😄