Creating a chart from field data
Hi all I'm a total newbe but I want to create charts from info in drop down menus. I have created a pie chart but it shows all records and divides it up equally according to how many records I have. For example 100 records = 1% each. I need to see what percentage each item on the drop down menu is. I have a security business so the options are - intruder, cctv, fire. I want so see a chart showing how many of each are in the database. I also need the same type of results showing services due in each month from drop down calendar field. I'm guess this will be the same answer for both problems. Thank you
If you have a summary field defined, you can use these options: Use Data from Current Found set and show data from groups of records when sorted to chart data where each chart element charts the sub total for a group of records.