Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Help, best way to gruop
Migrateduser
I use Birt 2.6.2 and I have a dataset like this:
Job1 Job2 Job3 Job4
+
+
+
Mary Mary John Gilbert
Richard Helen John Helen
Mary Helen Cindy Cindy
Mary Mary Mary Mary
Richard John Helen Helen
Mary Cindy Cindy Richard
Mary Cindy Mary Helen
Richard John Helen Mary
Mary Cindy Helen Helen
? ? ? ?
What is the best way to group, count and get a report like this?
User Job1 Job2 Job3 Job4
+
+
+
+
Mary 6 2 2 2
Richard 3 0 0 1
Helen 0 2 2 4
Cindy 0 3 2 1
Gilbert 0 0 0 1
John 0 2 2 0
.... ... ... ... ...
Some users may only be present in a column.
Thanks
Find more posts tagged with
Comments
There are no comments yet