I made a few Gauges following christophilus advice which visualize how much space is occupied on my servers.
I only care about a status for the present day so my workaround was to save dashboard with the time because I get new record only each day but I want to have my gauges on a dashboard with other charts and thus saving dashboard with the time is not an option.
How do I show only last records on a chart? Can I do it for example using some kind of special query like:
TIME >= CURRENT_TIMESTAMP - 24h ?