So I've been working on this report and slowly, step by step, things are starting to work, but I've run across an issue.

Couple of caveats:
I did not create this report, I am just adding onto it.
I am using Crystal 2016

I have 2 bar charts in the report header, not sure if they need to be there, but that's where I have them for now. We'll just focus on one chart for now.

In the "on change of" field there is a formula that I created for the date. This formula outputs the date as text and the date output is based on the number of days between a chosen start and end date. So under 8 days and each day is output, 8-30 days and the beginning of each week is output, etc. We'll call it {@Group Date}. I also added {@Group Date} as a group by field, moving it to the top of the group by list.

In the chart I have two values, a formula that obtains the percent of calls under 15 minutes ({@15 minute pct}), and another formula that obtains the percent of calls under 60 minutes ({@60 minute pct}).
The percent formulas, use respective sum formulas that sum by {@Group Date}. So {@15 minute sum} is sum({@15 minute tally}, {@Group Date}), and then {@15 minute pct} is {@15 minute sum}/{@total calls}. The same is true of the 60 minute formulas. The above results in a bar chart that displays the two percentages side by side for each date.

For the detailed portion of the report, I don't want the date to be the very first group. There are two other groups that I want above it, Section and Sub-Section. The issue arises when I try to move {@Group Date} down the group list, the graph I have created no longer represents accurate percentages.

Any help would be greatly appreciated.

Edited by jdclover - 22 May 2018 at 1:28pm

I didn't create them, they already existed, the group I created I put at the top of group expert when creating the graph, I need to move it below them in group expert for the rest of the report to work right. I thought because the graph was in the report header, that any grouping in the graph would not be considered unless I told it to, as I had to in the sum formula that I used, as well as in the on change portion of the chart expert. I guess my understanding of the chart expert and how graphs work when they're in places like the report header is a little off.

So I guess the question, is there a way for the graph to only consider the group date and not the section and subsection groups if I move the group date as the third group in the group expert? Or am I SOL? I'm guessing sub-report at this point.

Edited by jdclover - 25 May 2018 at 7:11am

Have not moved the graph, it's still in the report header.

No worries, I understand, understanding the description of a report is harder than just seeing it, as is my trying to explain it.

Let me provide some screenshots that might help a little. First this is a cross-tab that I created for the data, as they needed it displayed in this way as well:


On that for the percentages, I used embedded summaries, so percentage = Row 1/Row 3 and Row 2/Row 3. But that hopefully gives you an idea of what the chart is based on.

For the chart:


This could be due to my lack of Crystal knowledge, but the only way I could find to get the percentage in the chart to work like it does in the cross-tab was to sum the three tallies that were used and do the summing with a group as discussed in my first post, and then create a percentage formula. Without the grouping, I get something like this:


I'm not sure how to create the chart without doing that, and I've tried a number of different approaches.

or don't change the formula since you need it for your crosstab, but create a another one.