Link to home
Start Free TrialLog in
Avatar of van-coug
van-coug

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of van-coug
van-coug

ASKER

Thanks mlmcc! Much appreciated!