user09335

Discussions

Converting cumulative data to difference
Hi, In the following table, I want to change the 'count' column from cumulative to differences. So instead 20, 20, 30, 30, 30... I want it to be 20, 0, 10, 0, 0... It would be great to know what's the best way to do it. Thanks!
Active users last x days
I have the following dataset ( see the attached screenshot). It shows the userID active on a given date and the session time. I want to determine which users were active in the current week, t-1 week, t-2 week etc. As an output I want a table with the following columns: UserID, active this week column ( 0 or 1 value),…