Solved

Need help getting a count

Posted on 2008-10-09
13
194 Views
Last Modified: 2010-04-21
I have a report were I have the top 3 categories of our Helpdesk system.  I need to get a count for how many times each of these categories were used.  Anybody have an Idea on how to do this?
0
Comment
Question by:Icontech
  • 6
  • 5
  • 2
13 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 22679787
I assume you have a group in the report for the category.

If not add one

Then use the count function
Count({SomeField},{CategoryField})

mlmcc
0
 
LVL 16

Accepted Solution

by:
wykabryan earned 500 total points
ID: 22679803
a running total.  
give the running total a name
field to summarize: pick a field that is most distinct
type of summary: count

evaluate:
use a formula: {category field} in ['your','fields','here']

reset
never - grand total
or
On change of group
0
 
LVL 1

Author Comment

by:Icontech
ID: 22679876
Its grouped by Queue and then I used Nth most freq to find each category.  I have an N = 1, an N = 2, and an N = 3.  I need a count for each on of these when the queue changes. How do I get it do count just the category that is displayed without hard coding the specific category.
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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.

 
LVL 100

Expert Comment

by:mlmcc
ID: 22679908
Right click a field in the detail section
Click INSERT  --> SUMMARY
Choose COUNT as the summary function
Put it in the group footer

mlmcc
0
 
LVL 1

Author Comment

by:Icontech
ID: 22679935
This will give me the count for all categories in that group not just the top category in that group.
0
 
LVL 1

Author Comment

by:Icontech
ID: 22679953
I need the count for the number one must used category that was used by each queue.
0
 
LVL 16

Expert Comment

by:wykabryan
ID: 22679955
yeah.. mlmcc.. he only wants the count of the top 3.  and the top 3 change so he does not want to go into the formula and change it.

Well in theory.. you would want to read each one of your top 3 into a variable. Then cycle through and count where variable equals the column. But i am not sure how this is done.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 22679988
What groups fo you have on the report?

Where do you want the count shown?

mlmcc
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 22680011
So do you have it like this

Group 1 - QUEUE
Group 2 - CATEGORY

Try this idea
In the QUEUE group header add a formula

WhilePrintingrecords;
Global numberVar QueueCount;
QueueCount := 0;
''

In the CATEGORY group footer
WhilePrintingrecords;
Global numberVar QueueCount;
QueueCount := QueueCount + Count({SomeField},{CategoryField})
''

In the QUEUE group footer
WhilePrintingrecords;
Global numberVar QueueCount;
QueueCount

mlmcc
0
 
LVL 1

Author Comment

by:Icontech
ID: 22680226
I only have it groped by queue.  When I added the group by category it then shows all categories not just the top 3 most used.  This will not work because of that.  I only need the count for the top 3 categories used by the each queue.
0
 
LVL 1

Author Closing Comment

by:Icontech
ID: 31504714
Once I figured out the evaluation port it worked.  Thanks for your help. The part it took me a little bit on was [your fields here].  My field was the Nth formula that I used to figure out the top 3 categories.  Thanks for your help.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 22680590
In that case you will have to use formulas to count the records or a running total as wykabryan suggested.

mlmcc
0
 
LVL 1

Author Comment

by:Icontech
ID: 22680661
I did a running count with the evaluation of
{workitem_current_view.workitem_category_tree_value} = NthMostFrequent (1, {workitem_current_view.workitem_category_tree_value}, {workitem_current_view.owned_by_worker_name}).  I had to setup three of them.  What he said was exactly right I just had to figure out what the formula was.  And then also reset on group.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question