I am working with Crystal XI, and trying to create a stacked line chart. I have a categories (chart lines), number of changed items for the categories (vertical axis), and change dates for the items (horizontal axis). The chart should show the number of items changed for the top 5 categories (most items changed) by "for each week" of the change dates. Sounds so simple, but I can't seem to make it so.
Using a group chart with "top-5" category and "for each week" date groups, depending on group order gives me too many caterories (top 5 for each week, not the whole report) or multiple sets of week dates (one set for each category). And plotted data appears to be a combination of item count summaries for both group levels.
Using an advanced chart I tried "On change of" change dates and category, and "Show value" the sum of changed items. I get a single set of weeks, and only 5 categories, but the sum of items are way off. I think there needs to be a group for item counts in the report somewhere.
Any advice on creating a chart such as this?
Thanks,
Susan
Using a group chart with "top-5" category and "for each week" date groups, depending on group order gives me too many caterories (top 5 for each week, not the whole report) or multiple sets of week dates (one set for each category). And plotted data appears to be a combination of item count summaries for both group levels.
Using an advanced chart I tried "On change of" change dates and category, and "Show value" the sum of changed items. I get a single set of weeks, and only 5 categories, but the sum of items are way off. I think there needs to be a group for item counts in the report somewhere.
Any advice on creating a chart such as this?
Thanks,
Susan