name | ID | MBS | Count of MBS |
---|---|---|---|
smith | 123 | 60504 | 1 |
smith | 123 | 60505 | 2 |
Jones | 124 | 60504 | 1 |
moving reports from Oracle Bi to looker and a bit stuck as to how to achieve a table with the count dimension as above - each ID can have many MBS and need a running total or count by ID only.
In oracle Bi i can just create a dimension to count MBS by ID - is there a way to achieve this in looker?
thanks