I have the following 2 columns of pivot data:</br>
"Sent Date" is a filtered field. I want to plot the "Sent Date" on the X-Axis and the Lead Time on the Y-Axis. So there would be 14 unique data points with Y values ranging from 2 to 10. However, whenever I move the "Lead Time" field to the Values area (within the PivotTable Fields window), it changes to "Count of Lead Time" and my data updates to this:
I can't seem to figure out how to get the "Lead Time" column on the Y-Axis without it changing to this "Count of..." format and augmenting the data. Any insight would be most appreciated!
Sent Date | Lead Time |
2/2/2015 | 6 |
2/2/2015 | 7 |
2/3/2015 | 2 |
2/3/2015 | 3 |
2/3/2015 | 5 |
2/3/2015 | 8 |
2/3/2015 | 10 |
2/4/2015 | 4 |
2/4/2015 | 6 |
2/5/2015 | 3 |
2/5/2015 | 4 |
2/5/2015 | 5 |
2/5/2015 | 7 |
2/6/2015 | 6 |
Sent Date | Count of Lead Time |
2/2/2015 | 5 |
2/3/2015 | 8 |
2/4/2015 | 2 |
2/5/2015 | 6 |
2/6/2015 | 1 |