?
Solved

Having or something similar in webi report to only return counts greater than specified number

Posted on 2013-12-09
3
Medium Priority
?
1,203 Views
Last Modified: 2013-12-10
I'm new to webi and trying to use Having or something similar so a report only shows locations with 6 or more tickets opened against in the past 60 days.
In the query builder I brought in my needed objects and a filter for tickets created in the past 60 days. Now, When I'm building the actual report I can add a column that counts tickets by location, which is the first column and the count is the second column.
It is counting correctly, but I am trying to only pull in rows (locations) that have had 6 or more tickets opened in the past 60 days.
I've always used crystal reports or sql with command object, but not sure how to do it in webi. Its seems it has to be possible without a change to the universe. Any assistance would be greatly appreciated.
Currently getting something like this
Location      Cnt
balitmore         8
seattle              4
Las Vegas         7
Woodland        3
Albany              6
kalamazoo        2

But want this:

Location      Cnt
balitmore          8
Las Vegas          7
Albany               6
San Fran            2
0
Comment
Question by:van-coug
[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
3 Comments
 
LVL 101

Accepted Solution

by:
mlmcc earned 2000 total points
ID: 39708537
You can build a filter with a prompt into the universe along with the count object or you can use a report or block filter in WebI.

In WebI
  In the toolbars to the left of the fx there is a filtering icon.  It has a FUNNEL on it.
CLick the filter icon
IN the  new space that appears add your filter.
If you want it on the entire report click an area on the report like the report header
If you want it on a specific block or section click in the block or section
Drag your count object into the area
Set the filter

mlmcc
0
 

Author Closing Comment

by:van-coug
ID: 39709415
Thanks mlmcc! Much appreciated!
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

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 …
How many times a day do you open, acknowledge, or close an IT incident? What’s your process? Do you have a process depending on the incident, systems involved, and other factors? New Relic Alerts gives you options for how you interact with notifica…
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
This tutorial will introduce the viewer to VisualVM for the Java platform application. This video explains an example program and covers the Overview, Monitor, and Heap Dump tabs.
Suggested Courses

777 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