Forum Discussion
Solved
Minimizing matrix table
Hi I have matrix table there shows open task by owner and priority, but table going to be quite large, infect there are only showing one task per line. To try to minimize the table, I manual ...
Hi Lana012021,
If you add an index column so each task has a unique numeric ID, you can use such a calculated column:
Here's the code in plain text:
ID number = VAR cOwner = [Owner] VAR cPriority = [Priority] VAR cTaskID = [Task ID] RETURN COUNTROWS ( FILTER ( Data, [Owner] = cOwner && [Priority] = cPriority && [Task ID] <= cTaskID ) )In your mocking case, the Task ID column can be created like that:
Task ID = INT ( SUBSTITUTE ( [Task name], "Task", "" ) )Best Regards,
Alexander
Hi Lana012021,
If you add an index column so each task has a unique numeric ID, you can use such a calculated column:
Here's the code in plain text:
ID number =
VAR cOwner = [Owner]
VAR cPriority = [Priority]
VAR cTaskID = [Task ID]
RETURN COUNTROWS ( FILTER ( Data, [Owner] = cOwner && [Priority] = cPriority && [Task ID] <= cTaskID ) )In your mocking case, the Task ID column can be created like that:
Task ID = INT ( SUBSTITUTE ( [Task name], "Task", "" ) )Best Regards,
Alexander
Thank you very much it was really helpfull!