I'm sorry, I must have phrased it wrong. What I meant to say was that I
wanted the ID plotted against it's corresponding date each time it shows up.
I've tried a pivot table, but the data is incorrect. For example, one of the
ID's has only 2 errors on 2 different dates, but the chart shows it as if it
has 1 error on every date but 3. Those 3 dates are the dates that the user
actually had an error and it shows 2 errors on those dates, and the other is
one date where the user has no errors and it shows 0 (which it should). I
want the chart to reflect the actual number of errors per date.
|