How to show graph for sum metric

I have a sample data as below.

dataType,server,date,avg,tot
global,serv1,2018-08-28,6,60
global,serv2,2018-08-28,1,10
global,serv3,2018-08-28,2,20
global,serv4,2018-08-28,1,0

I want a graph which will show total of tot field of all the records for a given date. This is weekly data. We will get this data only once a week. I used metric sum on tot field. However it gave me below graph.

image

Is it possible for me to get a continuous graph instead?
Something like below…

image

I assume it is happening because I am have put interval as auto for sum query. It would have worked fine for avg function.