I have a large dataset with videos that have an upload date, and the the days following for views. Each video has a different upload date. Is there a formula i can use to get the first three days of views. Please let me know.
2 answers
Hi Anna
Try this calculation:
Latest 3 Days:
{ FIXED [Video ID]: SUM(IF DATEDIFF('day', {MAX([Upload Date])}, [View Date])<=2 THEN
1 ELSE 0 END)}
Add Latest 3 Days to filter and select Min value 1.
A sample TWBX will be very helpful to answer your question more efficiently.
Thanks,
Avinash.
