Count by groups in WEBI

[midwestdata]

Hello,

I need help creating a webi report that has a count by groups. eg -

Month Group Count
March Inside 5
March Outside 2
April Noted 1
April Inside 3 etc...

I don't know how to create these groups. The field to be grouped by, 'Group', is a dimension. The month field is a formula to get the month name from the date.

Any help is appreciated. Thanks.

 

[midwestdata]

By the way the Count is based of a unique id for each row in the database.

 

[skrandel]

You haven't really given us anything to go on. There is no Grouping functionality in WebI. But, groups are just if-then-else statements.

What version of WebI. What is the variable you would use to create the group?

Steve Krandel
Intuit

 

[midwestdata]

Version: XI R2
I didn't create a variable. I need to group by, lets say, Packet Name. I need the count of all IDs under each packet for each month. There are about 600 different packets. Total records are 100,000.

 

[hilfy]

Is there a count measure in the universe? If so, WebI should automatically handle the grouping for you - just put the month and group dimensions and the count measure in your report.

If it's not in the universe, you should see about adding it. You could include the ID number in the query but not display it on the report. Then create a variable using the Count function that will count the ID's for each entry in the group. However, this means that your report is going to be MUCH slower because all 100,000 rows will be read and downloaded and then WebI will have to do the calculation. If the count is set up as a measure in the universe, the database server will do all of the work and WebI will only download one record for every group member.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[midwestdata]

Thanks that worked. Pretty Simple eh!