Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try Count({1} User_Id)
When I select BU1 I get 5 when I'm looking to get 2.