Any help is greatly appreciated. In short, I'm trying to get from the blue line to the red line like in the picture below:
By distinctly counting the UID's below on the Rows shelf and showing date by month on the Columns shelf. (Data found in the attached excel document)
UIDDateComplete?ABC-16/25/2018ABC-29/13/2018ABC-36/21/2018ABC-49/13/2018ABC-59/13/2018ABC-65/15/2018ABC-73/21/2018ABC-86/21/2018ABC-96/21/2018ABC-103/21/2018ABC-116/21/2018ABC-128/16/2018ABC-136/21/2018ABC-147/30/2018ABC-156/25/2018ABC-1610/15/2017YABC-172/20/2018ABC-1810/15/2017YABC-192/20/2018ABC-2010/15/2017YABC-212/20/2018ABC-2210/15/2017YABC-232/20/2018ABC-2410/15/2017YABC-253/21/2018ABC-265/13/2018ABC-276/21/2018ABC-283/21/2018
2 answers
Thank you Justin. That gets me halfway there. The Other half I'm talking about is the line before my data (pre October 2017), showing the 28 for the Nulls (Black Arrow Below).
I was hoping I wouldn't have to pre-clean my data to accomplish this, hoping I could start with the raw data itself and get to the image above.
