Thanks Mynda for the soluction. So basically I need to create an intermediate table to have the calculations I want. Cannot use the raw data and in on...
Sorry I mean 18220. Just too many numbers around. getting confused. So total bug count should be 2 and not 3 what is currently being displayed for Cou...
Hi Mynda, Thanks for the quick response. What I intend to say is that when I count the number of Bugs it should be counted 18109 as 1 and not ...
Hi Mynda, Attached is a workbook which shows how I tried to achieve it in LastnMonths tab. I am sure you would come up of a better way of doing it ...
Hi Mynda, Thanks for the quick response. One concern that I see is with data increasing over the years the timeline would increase and lot of ...
Hi, Attached is the sample data for reference.
Hi Andres, Due to the sensitivity of the data I cannot share the exact file but the format would be the same as shared above. Also I cannot limit ...
Hi Mynda, It is more of a learning that I wanted to do and also the reason for limiting it to latest 6 months is to just fix it and user doesn...
Not sure why but it is very strange and it is driving me nuts. Such a simple thing and I am unable to implement it. Few of the observations: ...
Hi Andres I tried but still the same issue 🙁
Hi Anders thanks for helping me out. Attached is the link of the video with the process and the steps that I am trying to implement it.
I have tried using PQ also but it does not work. The PQ first defines it as a Text and when I convert it to Date/Time the 1st, 3rd and 4th record erro...
Thanks for directing me. Attached is the sample file. Thanks Sunil