Say I have an index with a dataset of all purchases done on an e-commerce site. For Black Friday, which falls on a different date of the month each year, I want to be able to compare how sales are this year compared to last year on Black Friday.
My initial instinct was to turn to timelion with an offset (e.g. make a sum of the sales amount, then do an offset of -1Y of the sum of sales). This actually give the exact graph I want - except for the tiny problem of the dates not being correct.
Is this solvable by Timelion, or some other component of Kibana? Maybe by some plugin?
Dream scenario would be to be able to choose two dates, and compare (in my case) sum of sales amount per hour in a graph.
(we solved it this year in a rather hacky way; indexing last years Black Friday sales (which fell on the 24th of November) into this years October 23rd, in order to do a timelion offset of exactly -1M -- but this only really worked because we had an empty index, and only really bothered about Black Friday)