2. ASPRunnerPro General questions
  3. chart
This topic is locked

chart

 		9/19/2012 6:06:54 AM
ASPRunnerPro General questions
M
 magma7247 author

Hi , I have simple log, it's one access database called Table1, it has the following fields

1- Date

2- Caller Number

3- type of call ( dropdown menu /which is the problem )

4- Agent

5- Comments if any
I create chart, and I want it to show only the value inside the ( type of call ) filed.

that filed has dropdown menu and has the following options

  • slow browsing
  • low download
  • weak line

    and so on.
    what happen now in my chart it's shows the similar problems as separated one instead of calculate the similar cases and shows the number of each problem.
    all what I want to show on the chart is how many slow browsing and how many weak line and so on.

    any idea ?I'm not experience on coding, so please be patient and keep it simple and easy.
Sergey Kornilov admin 9/19/2012

I'm not 100% sure I understand what the issue is but my feeling is you talking about aggregating your data.
If this is the case - check this article:

http://www.xlinesoft.com/asprunnerpro/docs/using_sql_to_shape_chart_data.htm
M
 		magma7247 author 9/19/2012

Hi, Admin,

I don't want to calculating digits, I want to count none numbers values, such as options inside dropdown menu.

let's say that I have dropdown menu has 5 options.

1- white

2- black

3- red

4- blue

5- yellow
I want to show in the chart, how many picked red and how many white and so on.
I upload the project and I opened ticket, and I hope you can help me with this.