Trying to understand how to define a query or panel that will always show data for a time range from the last “16th day of month” until now, so - as of this posting, it’s Feb 28, so I would want the time range to reflect Feb 16 - Feb 28. On March 3rd, I would want it to reflect Feb 16 - March 3rd. On March 17, it should reflect 1 day, March 16 - March 17 (maybe that’s 2 days, whatever).
I’m familiar with the “relative time” and “time shift” fields on the panel and I’m familiar the query fields, but I can’t figure out how exactly to achieve this.
Boy, that’s a good question, I think it’s influxql, but I’m game to change that if it’s straightforward to do? I think I’ve used flux from Chronograf, but not from Grafana, so if it’s something that’s doable in flux, but not so much in influxql, then just help me figure out how to do that?
