I have successfully added my SharePoint list as a source. I select fields to use as data, but the values are being shown as "1" and not the value of the field.
Example: "The Number of Sites per Day" --> I have created on the axis, and "# of sites" as the Value.
The bar chart shows each date with a bar value set to 1. The actual value of "# of sites" is in the thousands.
Example: There are 3 rows of data. Each with several columns. Each row, or item represents a snapshot of totals for that day. I'm trying to get a bar chart to show the trend of "# of Sites" for each day. However, when displaying this data it shows the data as though each line is a value of 1. Reguardless of what is in the columns i'm using.
Why is it counting this as 1, and how can I change it.
