Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
See attached qvw
Hi Gysbert.
As usually working fine!!
Thanks a lot.
Ariel