How to make a report showing the share of the groups

Hi everybod

I have difficulty explaining what I want but I know it well. So now I will try:
I want a report showing the share between the card-id that have opened a incident
I have a system where incident is opend and "reported by" is a Card-id

I have a report that cointains groups made by "Group Expert". I have made a summery per group showing the number of incident opend by the card-id

My report should show this

Card-id that has opende 2 incident = 27%
Card-id that has opened 3 incident = 35%
Card-id that has opened 4 icident = 18%
Card-id that has openden >= 5 incident = 20%
Grand total = 100%

I have attaced my report as It is so far.



 Antal-henvendeler-pr.-kort-nr..rpt
lkudskAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mlmccCommented:
Is this what you want?

mlmcc
Antal-henvendeler-pr.-kort-nr.-1.rpt
0
lkudskAuthor Commented:
No. That is not what I want.

I want a report showing how many times a person (in this report identified via card-id)
eg. we have 100 persons who have been approached the helpdesk and incident has been made (100 different cards ids) - how many of these Card-IDs have contacted the helpdesk 2 times, 3 times, 4 times. and so on
0
lkudskAuthor Commented:
So I think I should have a formula counting the numbers of card-id (group # 3 in my report) who has 2 incident, 3 incident, 4 incident etc. etc.
I just don't know how to make that formula. Maybe you can help me?
0
JavaScript Best Practices

Save hours in development time and avoid common mistakes by learning the best practices to use for JavaScript.

mlmccCommented:
0
mlmccCommented:
Sorry for got to add the %

mlmcc
Antal-henvendeler-pr.-kort-nr.-1.rpt
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
lkudskAuthor Commented:
Yes - that's exactly what I want. How did you do it? Tell tell so I can learn how?

Thanks in advance
0
mlmccCommented:
Look at the formulas used to display the values.

mlmcc
0
lkudskAuthor Commented:
How do I make a Pie with the result the you came with?

Right now when I try the Pie is not made by @DispAbove5 formula and therefor I can't get the right result with the Pie (persent or  numbers or both)
See attached screen dump report with pie
0
mlmccCommented:
How did you group the data?

mlmcc
0
lkudskAuthor Commented:
via Group expert
 I have attached the report  Antal-henvendeler-pr.-kort-nr.-1.rpt
0
mlmccCommented:
Because of the way the % are calculated you can't get  a graph to show them.

mlmcc
0
mlmccCommented:
Can you add a table to the database?

mlmcc
0
lkudskAuthor Commented:
What should it contain?
0
mlmccCommented:
1 column
5 records
1
2
3
4
5

mlmcc
0
mlmccCommented:
Here is a your report with a subreport added.

You need to change the subreport to use your new table.
Also in the GraphValue formula change my Field1 to your field name

mlmcc

Antal-henvendeler-pr.-kort-nr.-R.rpt
0
lkudskAuthor Commented:
Hi Mimcc,

I have now worked a little bit with the report and I found out that the figures/numbers doesn't fit/figures do not match compared to the expected.

I have via Group Expert made two groups
A. One group with "NOK" (incident opened without a card-id or without useful data)
B. one group with "OK" (incident opened with a card-id).

Group B contain 17.574 incident
But with the calculation in your formula (DispAbove5) the total numbers of incident is far from 17.574 (13.418 instead- it makes a difference 4156 incident). where have they gone?

Do you know?



0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.