Hi,
Another new ES user here, and I have the same issue as the original author.
On Friday, January 27, 2012 8:47:04 PM UTC, kimchy wrote:
Most charing systems can fill in the gaps easily for you, where you just
need to provide the ones with data.
Just FYI, this is actually not the case with many charting libraries. Say
you have the following data (pseudocode, obviously):
dates: ["March 21st", "March 20th", "March 19th", "March 18th", "March
17th"]
counts: [5, 6, 0, 10, 5]
Elasticsearch will return the following:
dates: ["March 21st", "March 20th", "March 18th", "March 17th"]
counts: [5, 6, 10, 5]
Most charting libraries will actually draw a straight line between 6 and
10, rather than dipping to 0 for March 19th as expected.
Although you can get round this by preprocessing the data, it's quite
fiddly. It'd be really nice if the date histogram facet at least provided
an option to include zero data points.
Cheers,
Jamie