Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have some record where document id is repeating according to the workflow status( preparation, review, approved). i would need to count the document id and sum it because if the uploading of the document repeats then it should count 2 2 , in case three times upload happens then count 3.
but in the final result i want to see group by on document number and count of the document. my load script looks like below:
source:
LOAD
Workflow_Name,
Workflow_Owner,
Workflow_Status,
WorkflowStartDate,
"DocumentName",
DocumentNumber,
"Type",
Subtype,
Version,
TaskVerdict,
TaskVerdictComment,
TaskVerdictReason,
EMEAProjectOwner,
TaskName,
NoOfFields(TaskName) as upload_counter ,
If(WildMatch(TaskName,'*Upload Content*') and WildMatch(Workflow_Name,'*Upload*'),1) as counter,
TaskOwner,
TaskAssignmentDate,
If(WildMatch(TaskName,'*Upload Content*') and WildMatch(Workflow_Name,'*Upload*'),date(TaskAssignmentDate), '31/12/2025') as firstloaddate,
TaskCompletionDate,
Country
FROM [lib://PHARMA - DATAMARTS/Bene/EMEA - BeNeLux Workflow Report_Feb.xlsx]
(ooxml, embedded labels, table is Sheet0);
file_upload_counterTable:
Load
distinct
DocumentNumber,
Workflow_Owner as 'Owner',
Workflow_Status,
WorkflowStartDate,
DocumentName,
Sum(counter) as Counter
// firstloaddate
Resident source
Group By DocumentNumber,
Workflow_Owner ,
Workflow_Status,
WorkflowStartDate,
DocumentName;
my result coming wrong. The document number is repeating in the result. can anyone help me with the result where i can get distinct document number with respect to accumulative sum of number of upload.
result below:
Remove FirstloadDate field from chart as well as in chart use expression sum(Counter)
If this don't work then provide sample data with expected output.
Regards,
Prashant Sangle
i have tried removing the firstloaddate and also taken sum(counter), still its repeating. its not working.
What is your expression for Counter in chart???