Skip to Content
0

How to Break Date Column to Count Occurances per Date per Owner | SAP BI

Feb 06 at 12:43 PM

24

avatar image
Former Member

Hello,

Assuming that I have the below data.

Ticket Owner Closed Date

-------- --------- ----------------

A112 John 1-Feb-18

B113 Marry 2-Feb-18

C354 David 1-Feb-18

A343 John 1-Feb-18

A347 John 2-Feb-18

Then, how can I find the total closed per owner per date?

Owner/Date 1-Feb-18 2-Feb-18

---------------- ------------ -------------

John 2 1

Marry - 1

David 1 -

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Koen Hesters Feb 08 at 08:15 AM
0

Hi,

if you just want a count on John and Date then create measure count([Ticket])

and add Name Date and the new measure in a table

Grtz

Koen

Share
10 |10000 characters needed characters left characters exceeded