How to change time interval on x-axis of a graph to 10 minutes instead of 1 hour using dbquery?

[usha_nittala]

Hi All,
Is there any way we can change the time interval on x-axis to be 10 mins instead of 1 hour using dbquery.

My sample query looks like this:

| dbquery testDB "select SRC_DB,TOTALLAG,DELGROUP,EXTRACT_NAME,UPDATE_TIMESTAMP from COMDBA_ID.GGS_HEARTBEAT_HISTORY" | rename UPDATE_TIMESTAMP as time | convert timeformat="%d" ctime(time) AS date | convert timeformat="%H" ctime(time) AS hour  | chart avg(TOTALLAG) as TOTALLAG by hour DELGROUP

Thanks in advance.

Usha

[strive · Accepted solution]

In your search you are calculating average by per hour basis. That means every one hour you will have one point to plot on chart. If you want it to be every 10 minutes then you need to change your search.

[strive]

Yes. Set time buckets of 10 minutes and then calculate average using your chart command.
One suggestion -- I do not see the usage of date in your search, so you can stop extracting date.

[usha_nittala]

Thanks strive, so do I need to use something like sysdate in my dbquery or use some option with chart?