[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1239
  • Last Modified:

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

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
van-coug
Asked:
van-coug
1 Solution
 
mlmccCommented:
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
 
van-cougAuthor Commented:
Thanks mlmcc! Much appreciated!
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Tackle projects and never again get stuck behind a technical roadblock.
Join Now