Why is Graph building so hard?

[brendandaly]

I need to figure out how to put together a graph based on counts of records of different types. There are 4 different categories the the records can fit in: DEA, NPI, Medicaid Sanctions and OIG Sanctions. In addition, under each of these categories, the records can be either "good" or "bad." Plus I need to be able to track this over quarters. What I'm thinking is having 4 different graphs, one for each category, have the x-axis be quarter and the y-axis be the number of records and for each quarter one bar of "good" and one of "bad". This seems so simple but I can't get it working at all. In fact, when I try to make it I get a graph with numbers that don't make any sense and the x-axis is 'east, west, north' which is nowhere in my database. I haven't found anything helpful on the internet at all for this and the graph wizard is a POS. I've even taken a number of statistical analysis classes and still can't figure this out. Please help! Anything is appreciated.

 

[AUGuy]

Hi! There are a few things that will help us help you with your issue. The first is a better description of the table(s) used in your database, any queries used to calculate graph data, etc. For example: "I've got a table "TableName" with fields "FieldName1, FieldName2, ...".

Second, what does "good" and "bad" mean? Is this indicated by a field?

The east/west/north thing might be default values to illustrate positioning that you haven't changed yet. I'm not completely clear on your problem so I'm not sure.

Flesh this out a little and I'll do my best (as will others) to help you out.

Just as an aside, classes in statistical analysis really have no bearing on ability of a person to comprehend and utilize software. As such many people, classes or not, use the graph wizard without any problems at all.

Regards,
G