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?
 
mlmccCommented:
Sorry for got to add the %

mlmcc
Antal-henvendeler-pr.-kort-nr.-1.rpt
0
 
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
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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
 
mlmccCommented:
0
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.