I am trying to create a panel that displays the results of a db relative to now. From now-180d to now+30d. This is used for displaying forecasting. The time range is specific to this panel, defined inside the query and not taken from the timerange selector field on top.

SELECT date AS time, namespace, value FROM pnf_vnf_forecasting WHERE date BETWEEN $__timeFrom(now-180D) AND $__timeTo(now+30D) AND namespace IN($PGW) ORDER BY time ASC

Tried this query but the date between sections do not seem to take any effect. I read the documentation and it seems that timeFrom and timeTo take their values from time range field.

I changed the query options and was able to see relative to now and ignore the time range field but cannot display future values.

How can this be done?