Forum Discussion

Chavas's avatar
Chavas
Helper II
5 years ago
Solved

How to count multiple iteration on the same cell

Hello I am facing an issue on how to get a measure.

I have a table called tasks.

Each task row has a cell called Details which is fulfilled like this

************************************ 13-Aug-20 1:27 AM @ Person1: ************************************
lorem
************************************ 12-Aug-20 4:44 PM @ Person2 ************************************

ipsum

************************************ 12-Aug-20 6:00 AM @ Person3 ************************************

lorem

************************************ 10-Aug-20 13:27 AM @ Person2 ************************************
ipsum


And I will need to count the times that a Person has written for the last: 7 and 30 days for the whole table.
So I can produce a table like this:
 

 Last 7 daysLast 30 days
Person 1     13
Person 2    48
Person 3   36



Splitting by delimiter is not a way as far as n columns may appear so I have no idea on how to filter.

I am thinking and I have no clue on how to do it. Any advice will be fantastic

Thanks in advance

Need Help
  • Chavas's avatar
    Chavas
    5 years ago

    I fixed it.

    What I did is splitting by rows on the query by the **** array.
    Then with manipulation I get all the times at one column and set the column type as data.

    Remove all the errors

    From here is pretty straight forward.

1 Reply

  • Chavas's avatar
    Chavas
    Helper II
    5 years ago

    I fixed it.

    What I did is splitting by rows on the query by the **** array.
    Then with manipulation I get all the times at one column and set the column type as data.

    Remove all the errors

    From here is pretty straight forward.