Forum Discussion
Matrix issues
Super UserHi,
Share some data and show the expected result.
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
- Ashish_Mathur
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 #'
