Chart data selection

[Former Member]

I'm trying to make a chart like you would see on an electric bill. On the X axis of the chart, the dates for 13 months show, and the bars show the amount of kWh the customer had for each month. When I go to pass in the fields in the chart expert I try to select "On change of" Show values . This keeps coming up as "count of kwh" in the "Shoe values:" box. The information displays the dates correctly at the bottom with all 13 columns.. but the bars are wrong. They all go up to the value of 1.0 then stop. The KWH values are more a long the lines of 800-2000. Am I doing something wrong? I don't want it to take a count of the KWH.. but to actually read the values in the database and then display the information from there. Please help! Thanks.

[Former Member · Accepted solution]

You can change the summary type in cross tab from count to sum, if KWH values are of number type.

can you check whether KWH values are string data type?

Hope this will help.

Jyothi

[Former Member · Accepted solution]

Okay, how would I change it? Where is cross tab? I see a button below the Show Value(s): box that says Set Summary Operation but when I go to it all my options are "Count" and "Distinct Count". KWH is in the database as a number.

[Former Member · Accepted solution]

I think KWH is a string type.

Can you go to field explorer, right click on the database fields and check the show field type option. It will show the data type of the fields. Check whether KWH is string type.

Jyothi

Edited by: Jyothi Yepuri on Jul 23, 2009 2:15 AM

[Former Member · Accepted solution]

Hmm I think you're right.. my SQL server is saying it's a varchar. If I change it to int will it fix the problem?

[Former Member · Accepted solution]

Yes. But before check the data in KWH field whether it can be converted to number type.

Thanks,

Jyothi

[Former Member · Accepted solution]

Thank you! I checked my program and it will let me convert to the number type without many problems. As soon as I did summary came up and it worked wonderfully. Thank you for your help.