Forum Discussion
new column for matrix with weekly-live items
Happy pandemic Forum, I have a matrix with: 1. A list of 20 deliverables with dates to be delivered (plan sum) and dates they get submitted (sub sum) - these are sourced from two separate spread...
Hi Mike_Mace
I can download the link. But I'm a little bit confused that what results you really need. Can you show me your expected visual in the form of a table?
Best Regards
Caiyun Zheng
Thank you for looking into this
I am sending a new link with adjusted data as it matters to see which week the calendar is at currently. I am sending the pbi file and a spreadsheet
The spreadsheet first 2x tabs have the data.
The other 3 tabs have the goal table. One for whenever the current week changes.
- matrix column "plan sum" counts the data from tab "plan date" (columns A&B)
- matrix column "sub sum" counts the data from tab "submission date" (columns A&B)
- matrix column "failed" is a measurement on pbi file. It counts items that were expected for submission but not submitted
- matrix column "plan+" is the goal. when an item is expected to be submitted but fails, then the item will keep appearing on new current week under "plan+" until the item is finally submitted under "sub sum".
- For example, see item "v" expected to be received week 15th March 2021 but failed. It was then expected under "plan+" on week 22nd March 2021 but was not submitted again, hence kept appearing under "plan+" in the future weeks too.