Bar chart adding extra bars when using calculated value
Posted: Tue Jul 03, 2012 2:49 pm
I have a two page report with the second page containing a simple bar chart.
If I use a calculated value, i.e. { DataSource.serviceTime / DataSource.customers}, it displays the data correctly but then adds extra values after that with an incremented axis label.
For example:
The SQL query returns two rows. Each row contains total service time and total customers.
The report renders like this:
Location A, Location B, Location C, 3, 4, 5, 6, 7
What is creating those extra columns, 3 through 7?
I've attached screenshots of the resulting graph and the Series editor.
If I use a calculated value, i.e. { DataSource.serviceTime / DataSource.customers}, it displays the data correctly but then adds extra values after that with an incremented axis label.
For example:
The SQL query returns two rows. Each row contains total service time and total customers.
The report renders like this:
Location A, Location B, Location C, 3, 4, 5, 6, 7
What is creating those extra columns, 3 through 7?
I've attached screenshots of the resulting graph and the Series editor.