How to do an Absolute Count

Mon, 24 Sep 2012 21:00:31 GMT

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.

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.

Re: How to do an Absolute Count

Mon, 24 Sep 2012 21:58:54 GMT

Try Count({1} User_Id)

Tue, 25 Sep 2012 13:40:07 GMT

When I select BU1 I get 5 when I'm looking to get 2.