Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
Solved

Need help getting a count

Posted on 2008-10-09
Medium Priority
198 Views
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
Question by:Icontech
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• Learn & ask questions
• 6
• 5
• 2

LVL 101

Expert Comment

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

wykabryan earned 2000 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

ID: 22679876
Its 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

LVL 101

Expert Comment

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

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

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

LVL 16

Expert Comment

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 101

Expert Comment

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

Where do you want the count shown?

mlmcc
0

LVL 101

Expert Comment

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

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

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 101

Expert Comment

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

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

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 â€¦
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as formâ€¦
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on tâ€¦
Suggested Courses
Course of the Month6 days, 10 hours left to enroll

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

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