Timechart on Bar graph showing null space

[DataOrg]

In timechart command used cont=false and in table statatics its not showing data on empty values but in bar graph . the empty/not present days showing gap in the graph

| timechart cont=false span=d sum(Negotiate) as "Negotiate", sum(Submitted) as "Submitted", sum(Draft) as "Draft",sum(Agreed) as "Agreed" sum(PartlyAgreed) as "Partly Agreed", sum(Empty) as "Empty", sum(Rejected) as "Rejected",sum(Obsolete) as "Obsolete", sum(NA) as "N/A", values(Total) as Total

premranjithj_0-1643787300427.png

[ITWhisperer · Accepted solution]

timechart fills in the times between earliest and latest and _time is given special treatment in some charts so that the whole time line is shown. To undo the "helpfulness" of timechart you may have to do something like this

| bin span=d _time as Time
| chart cont=false sum(Negotiate) as "Negotiate", sum(Submitted) as "Submitted", sum(Draft) as "Draft",sum(Agreed) as "Agreed" sum(PartlyAgreed) as "Partly Agreed", sum(Empty) as "Empty", sum(Rejected) as "Rejected",sum(Obsolete) as "Obsolete", sum(NA) as "N/A", values(Total) as Total by Time
| fieldformat Time=strftime(Time,"%F %T")