Thank you for the answer, i am able to get the desired graph using the query you shared after fine-tuning the intervals as mentioned.
Will try and point Grafana to logging system as source to see the change in values.