Skip to Content
avatar image
Former Member

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

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 -

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Feb 08 at 08:15 AM

    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

    Add comment
    10|10000 characters needed characters exceeded