Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Help! Metric Problem

Help! Metric Problem

Help! Metric Problem

Hello All,

I'm doing a report where i find employee productivity for a given
period. The possible cases are

 An employee can visit a new shop for enrollment(initial visit).
 Already existing shop given a follow-up call.
 Finally he might enroll that shop one day..

This is how it should look ultimately

Employee Name    No Of        No of        No Of
                  Enrollments         Calls Made         New ShopsMet


Now my problem is for a given week there might zero enrollments in
which i wont get any values for 1st column but calls and new shops
wud have been made... because of that it says query returned no data...
when i remove the No Of Enrollments metric i get the output...

Is it possible to make a metric show 0 if it didn't get any values in
my case No of enrollments should say 0 and rest should give the real

Also should i put the date range filter in each metric or confining to
report condition will do fine...

Any help will be appreciated



RE: Help! Metric Problem

in the data>>report data options in edit mode of report, change the join type of your metrics to "outer join".  now the row will show up if any of the metrics is non-null.


RE: Help! Metric Problem


i want rows to show up when a metric value for that is null.

anyway i've tried doing outer join, still the employee's who haven't done a convertion
doesn't show up.... if an employee has done some convertions it shows the details for
that employee only but i want other employees to be listed with convertion displayed
as 0....

if i don't take emp attribute in the report part i get a single row with convertion as 0...
cud u help me fix this one....

hope the question is clear...



Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close