Hi All,
I'm currently developing a dashboard that is requiring an total absolute count of headcount relative to what is selected. Below is an example.
The two tables are joined by User_Id
If I select Jan_2012 I get the following results.
| Org_table: | Ticket_table: |
| User_Id | Bus_Unit | User_Id | Month_Year | Ticket_Id |
| Usr1 | BU1 | Usr1 | Jan_2012 | Tkt1 |
| Usr2 | BU1 | Usr2 | Feb_2012 | Tkt2 |
| Usr3 | BU2 | Usr3 | Feb_2012 | Tkt3 |
| Usr4 | BU2 | Usr4 | Feb_2012 | Tkt4 |
| Usr5 | BU2 | Usr5 | Feb_2012 | Tkt5 |
| Count (User_Id) | Count (Ticket_Id) |
| Result | 1 | 1 |
| Desired Result | 5 | 1 |
If I select BU1 I would get a count of 2 and ticket count of 2.
I'm basically trying to do a count on the User_Id field within the Org_table regardless of the associative records of the Ticket_table
Thanks for any help or suggestions.
