Forum Discussion
Matrix issues
Hi Ashishs,
I'm attaching an image since as a regular user I'm not able to attach files to the forum:
Sample Data
From the above I need to build a Matrix that looks like:
| Week 41 | Week 42 | Week 43 | Week 44 | Week 45 | Week 46 | |
| Completed | 8 | 3 | 5 | 0 | 1 | 2 |
| Invalid | 1 | 0 | 1 | 0 | 3 | 2 |
| Opened | 1 | 7 | 3 | 8 | 4 | 7 |
| Ongoing | 55 | 64 | 73 | 85 | 77 | 81 |
Where the first issue is that I cant get zeros in my matrix, it shows a blank cell.
Like the one on my previous response.
The second question, is to see how can I make my report to only show the last 5 weeks without the use of a slicer, that's why I mentioned maybe a calculation that counts the number of weeks?
And another and bran new issue that I have, is that the row "ongoing" is the sum of open problems up to that week, this last calculation I have not figure how to make it either...
Hope this helps in explaining what I'm looking for.
Thanks and regards,
Vicente
Hi,
My first doubt is - How do you determine the week number? Do you use the WEEKNUM() function? Is the week number determined with respect to the Created date/Closed Date? Plesae clarify.
Yes, I have 2 columns:
1 - Week # = Weeknum(Created)
2 - Week = "Week " & 'Week #'
Hi,
Share the link from where i can download the PBI file.