Forum Discussion
Multiple date difference and date count in a string
Hi, can anyone help me with implementing this? In my Dashboard I have 4 columns: A) Number of the issue B) Person Handling the issue C) Creation Date of the issue D) Comments on the issue ...
Hi Anonymous ,
for spliting your each cell into 4 columns, you can use Split in your Transform data:
After Splitting, click on group by:
Use your Person Handling column.
Then create a column:
Result = Calculate(Count(Comments), [Handling_Person] = EARLIER([Handling_Person), [issue_no] = EARLIER(Issue_no), ALL(tablename))
By this, your 1st issue will be resolved.
truptis , your solution to split the columns splits the text incorrectly. Are you sure that "/" should be the delimiter?