Grafana showing last value if the query doesn't return any or till it return new change

Grafana version: latest
Im using Prometheus data source and query exporter to export the query,

So, i wrote a Oracle SQL query to return the data of current date, so query working fine but in grafana time series dashboard if the value of particular colom is not there the dashboard extending the last value

In graph you can see the second line had data yesterday but when i refresh and see the last value is being extended till some value or different count is returned…

For your information I’m using two transform [


My expectation is the grafana should not extend the last value instead it show no data or 0 if the value not returned from query

Please help :pray: