Visualize data to spot the errors
May 25, 2013
Posted by on
In the first chart, I plotted data on an aggregation report I built. Because of the visualization, I discovered gaps in the reporting data.
In the second chart, I changed the resolution for hourly, to every three hours and the gap was still there.
The third plot is each data source plotted separately, notice no gaps it the original source data.
What I discovered was a built in flaw in the library I was using to aggregate data or my poorly implemented method. Albeit, I re-implemented a custom aggregator to fix the problem.
I found a related post http://gigaom.com/2013/05/24/steering-clear-of-the-iceberg-three-ways-we-can-fix-the-data-credibilty-crisis-in-science