Forum Discussion
TBensen
Helper I
Helper ICounting Status changes across multiple Rows utilizing date fields
Hello, I have any interesting count I'm trying to run and I'm having some issues trying to get the right answer. To lay the ground work and what I'm looking to accomplish, here is what I have. ...
you can try to createa a step column
step =SWITCH('Table'[Workflow Stage],"Draft",1,"Verification",2,"Investigation",3,"Approval",4)then create the overdue columnColumn =var _draft=maxx(FILTER('Table','Table'[Record ID]=EARLIER('Table'[Record ID])&&'Table'[step]=1),'Table'[Workflow Date Modified])var _inve=maxx(FILTER('Table','Table'[Record ID]=EARLIER('Table'[Record ID])&&'Table'[step]=3),'Table'[Workflow Date Modified])return if('Table'[step]=1 &&'Table'[Workflow Date Modified]>_draft+1,1,if('Table'[step]=3 &&'Table'[Workflow Date Modified]>'Table'[Investigation Due Date],1,if('Table'[step]=4&&'Table'[Workflow Date Modified]>_inve+5,1,0)))pls see the attachment below
TBensenHelper I
Helper IHello,
I think this might work! One thing I am seeing is that it appears to only be showing an Investigation or Approval workflow stage as being overdue. Is there a way to apply this to the Verification stage which has a due date of +1 after the Draft stage has been completed?
Would I add another If statement into the Return formula to to look at "Step=2" and WorkflowDate Modified > _draft+2?
Thanks,
Trevor Bensen
