Good morning,
Thank you for your help with this query. The goal in getting the data in that format is that I then have to look for each USERNUMBER add a conditional statement if the weight on a given day is greater than 500.000 or not, then add how many USERS had a weight over 500 and how many didn't on each day in April. I used your code and it worked in filling in the missing dates and also filling in with previous weights on the missing date (thank you). However, I have over 80,000 unique usernumbers, this means that I should have that many number of columns (splunk truncates them to show just 10). I tried transposing the result so I can instead have a table like this:
USERNUMBER 04/02/2020 04/03/2020
545 245.2400 260.2400
but I still got only 10 USERNUMBERS/rows.
Given these details, what would be the best way to display the data so I can add the conditional statements? Thank you again for your help.
... View more