Cross Tabs and Graphs

[Cyked]

Trying to do charts for data in a report or even from a cross tab...
Assume I have a report by month, assignment team, ticket priority, and ticket duration.

I can do a bar chart from this showing month, team, and duration, but I can't also show Priority. Is there a way to add more data to the chart that is still actually readable?

If I dump the cross tab data to excel I can show the data so that each team has two bars for the month. One for P3 tickets and one for P4 request tickets. But in Crystal Chart Expert you only have "on change of", "subdivided by", and "show". So I can only do the X axis of date, subdivided by team, and show the duration as the Y axis. Can I add a "fourth" data point in crystal?

Personal I just would rather look at the data, but management loves their charts.....

 

[lbass]

You could either insert a group on month and place the chart there with one "on change of" field (team) and multiple summaries (duration by priority), or you could possibly concatenate month and team (although I'm not sure this would look nice).

-LB