I'd like to print a grouped response such that it shows items with no data. Similar to what Excel offers with Pivot tables.
For example, let's say I'm grouping by error response and doing a timeslice by day. For this particular result set, I have 200, 500 and 502 responses being returned. For any one day, I'd like the aggregates table and corresponding graph to show each error code on every day even if the count was 0.
This makes the graph much more clearly read when trying to view a trend. That is, its helpful to see the spikes at the times that the errors occur. Instead what happens is periods of time when no errors occurs are simply omitted. Dropping items with no data gives an invalid picture of the data - especially with something like an line plot.
Please sign in to leave a comment.