Hello all,
I need help with the following:
i have a table like this:
| Object_Type | Object_ID | DATE |
|---|
| AAA | 1 | 01/01/13 |
| AAA | 2 | 01/01/13 |
| AAA | 3 | 02/01/13 |
| AAA | 2 | 05/01/13 |
| AAA | 1 | 05/01/13 |
| BBB | 1 | 01/01/13 |
| BBB | 2 | 01/01/13 |
| BBB | 3 | 01/01/13 |
| BBB | 4 | 01/01/13 |
| BBB | 4 | 02/01/13 |
I need to count only the first Object_Type & Object_ID .
Discard the raw's in bolt.
If I will use count(Object_Id) in expression and Object_Type and Date in Dimensions I will get:
| Object_Type | DATE | Count(Object_ID) |
|---|
| AAA | 01/01/13 | 2 |
| AAA | 02/01/13 | 1 |
| AAA | 05/01/13 | 2 |
| BBB | 01/01/13 | 4 |
| BBB | 02/01/13 | 1 |
I need that the table will be like:
| Object_Type | DATE | Count |
|---|
| AAA | 01/01/13 | 2 |
| AAA | 02/01/13 | 1 |
| BBB | 01/01/13 | 4 |
How can I achieve that?
BR
Ariel
