NAME : <<Start:FILTER(
"task_mngt",
[task_mngt_id]=MAXROW(
"task_mngt",
"_RowNumber",
AND(
[name]=[_THISROW-1].[name],
[department_id]=1
)
)
)>><<[name]>>
<<Start:FILTER(
"task_mngt",
[task_mngt_id]=MAXROW(
"task_mngt",
"_RowNumber",
AND(
[name]=[_THISROW-2].[name],
[status]=[_THISROW-1].[status],
[department_id]=1
)
)
)>>
<<[status]>>
TASK | INITIAL TARGET |
<<Start:FILTER( "task_mngt", AND( [name]=[_THISROW-2].[name], [status]=[_THISROW-1].[status], [department_id]=1 ) ) >><<[main_task_name]>> | <<[task_target_date]>><<end>> |
<<End>>
<<End>>
@SkrOYC @Steve please help me finding this error. Thanks
Solved! Go to Solution.
So I think this is to do with the general layout of your template. Its says it can't find the 3 <<START: sections, which is weird. But I've had this before and sometimes its a formatting error where its not reading carriage returns right.
What I'd do is to build it in stages. Get your first start command working. Then add the second inside that one.
But also, all 3 start commands are referencing the same table? Why do you need them grouping this way? Normally I'd do this with formulas in the template.
So I think this is to do with the general layout of your template. Its says it can't find the 3 <<START: sections, which is weird. But I've had this before and sometimes its a formatting error where its not reading carriage returns right.
What I'd do is to build it in stages. Get your first start command working. Then add the second inside that one.
But also, all 3 start commands are referencing the same table? Why do you need them grouping this way? Normally I'd do this with formulas in the template.
Yes all the start commands refer to the same table. I really wanted to just group my data per employee and the status of their task.
So that would only need two start commands. Or just one if you were happy for the data to look like
User Task
User1 Task1
User1 Task2
User1 Task3
User2 Task1
User2 Task2
User2 Task3
User Task Status
User1 Task1 Done
User1 Task2 Pending
User1 Task3 Done
User2 Task1 Done
User2 Task2 Done
User2 Task3 Pending
User 1
Done Task
Task 1
Task 3
Pending Task
Task 2
I want my report to look like this,
Do you have seperate user and task tables?
It's okay now. I follow your advise. Thanks
User | Count |
---|---|
17 | |
11 | |
7 | |
5 | |
5 |