Forum Discussion
Aggregating Historical Data
I have X number of previous months data with a computer name, model, serial number, last online date. January A , laptop a , 2ac , 1/17/17 B , laptop a , 5ga , 1/27/17 C , laptop b , n3f , ...
I'm not having any trouble with the refresh the data is static. I'm having trouble performing the correct data operation detailed in my original post. I don't believe that the refresh affects my ability to do this:
if "computer name" exists, add column "Last date seen.1"
else add new row, set "Last date seen" = null, rename "last date seen" to "last date seen.1"
bump